How to get Table's field name as rows

Question

Post reply

How to get Table's field name as rows

nitinkumar_tss

Old Hand

Points: 331
More actions
May 6, 2009 at 1:36 am

#130678

Hi all,
I have a table like
T1
==================
Name Address
==================
abc xyz
I need the result of select query as
=========
fields
=========
Name
Address
How can i do this. Please help.
Thanks
Nitin

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

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

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

select name from sys.columns where object_id = object_id('Tablename')

"Keep Trying"

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 2

or

Select column_name from information_schema.columns

where table_name='your_table'

Madhivanan

Failing to plan is Planning to fail

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

Tables have fields???? 😀

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 4

I agree with the use of the information_schema instead of the system tables. There've been quite a few changes in how those system tables behave, what you can, etc., between 2000 & 2005/2008. The information_schema is pretty stable & standard between all the versions. A much better place to go.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning