How can we select all the column names of a table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How can we select all the column names of a table

Author

Topic

anupalavila
Yak Posting Veteran

56 Posts

Posted - 2008-12-04 : 01:34:52

Hai

How can we select all the column names of a table

Thanks and Regards
Anu Palavila

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-04 : 01:36:45

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'xxxcxvxcv'

E 12°55'05.63"
N 56°04'39.26"

anupalavila
Yak Posting Veteran

56 Posts

Posted - 2008-12-04 : 01:47:17

Thanks Patro Saint for your quick answer

Thanks and Regards
Anu Palavila

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-04 : 02:09:38

Also

select * from syscolumns where OBJECT_NAME(id)='yourtablename'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources