Listing Columns names in a tabel Query

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

DavidT SSCommitted Points: 1727 More actions · Answer 1

Try having a look at the INFORMATION_SCHEMA. Views in SQL Books Online.

eg:

select * from INFORMATION_SCHEMA.Columns where Table_Name = "TableName"

vlevesque Newbie Points: 2 More actions · Answer 2

Newbie

Points: 2

December 2, 2003 at 12:27 pm

Works Great, thanks for the info.

Mark Harr SSCrazy Eights Points: 9921 More actions · Answer 3

SSCrazy Eights

Points: 9921

December 3, 2003 at 5:43 am

Or sp_help <tablename> (easier to type)

Mark

cneuhold Hall of Fame Points: 3375 More actions · Answer 4

hi!

have a look at

for more comprehensive information

best regards,

chris.