Get columns of a table SQL SERVER

Question

Hi How can I get the name of all columns of a table in SQL SERVER 2008?

Thank you

Answer 1

You can obtain this information and much, much more by querying the Information Schema views.

Answer 2

Hi

You can use the stored procedure sp_columns which would return information pertaining to all columns for a given table. More info can be found here http://msdn.microsoft.com/en-us/library/ms176077.aspx

You can also do it by a SQL query. Some thing like this should help -

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.yourTableName')

I hope this helps.

cheers

Answer 3

by using this query you get the answer select Column_nmae from from Information_schema.columns where Table_name like 'table name'