Return Column Names from a Table 1

[codeWarrior456]

Is there a way to write a query that just returns the names of all the columns in a given table? If so, how can this be done?

Thanks for your help in advance.

 

[swampBoogie]

select column_name 
  from information_schema.columns
 where table_name = 'GIVEN'

 

[codeWarrior456]

Thanks!

 

[clarkin]

have a look at the built in stored procedures sp_help and sp_columns too:

sp_help GivenTable
sp_columns GivenTable

Try them out in QA - sp_help gives you lots of useful info.


Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].