MS SQL: Getting column names using sql

I forget this one, so...
select column_name,* from information_schema.columns
where table_name = 'YourTableName'
order by ordinal_position

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/5995c1d...