Determining table's column name in sql server

[Jinendra]

I have a sql server running. Is there anyway to find out the column name with a query. I don't need any data for the same but just the column name. Help guys!

[Eric B]

Try this query, may be thsi is what you want :

SELECT column_name
FROM information_schema.columns
WHERE table_schema = 'schema_name'
AND table_name = 'table_name' ;

[Raine]

One other way, that may work :

SELECT table_name, column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'my_table_name'

[Glenny]

This may work for SQL 2005 and above versions :

SELECT name
FROM sys.columns
WHERE [object_id] = OBJECT_ID('dbo.tablename');