How To List The Columns In Your Table

I wanted to inspect, in T-SQL code, the list of columns in a table I had created. This is how I did it:

select c.* from sysobjects o inner join syscolumns c on o.id = c.id

where o.xtype = 'U' and o.name = 'myTableName'

And for reference, a handy page on the T-SQL system tables:

• http://msdn.microsoft.com/en-us/library/aa260604(v=SQL.80).aspx