December 2, 2003 at 7:53 am
Is there a way to list the columns names in a table through a query?
Thanks,.
December 2, 2003 at 8:03 am
Try having a look at the INFORMATION_SCHEMA. Views in SQL Books Online.
eg:
select * from INFORMATION_SCHEMA.Columns where Table_Name = "TableName"
December 2, 2003 at 12:27 pm
Works Great, thanks for the info.
December 3, 2003 at 5:43 am
Or sp_help <tablename> (easier to type)
Mark
December 4, 2003 at 5:58 am
hi!
have a look at
http://qa.sqlservercentral.com/scripts/contributions/246.asp
for more comprehensive information
best regards,
chris.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply