read column names from at table

Question

Hello

Read column names from at table

 

 

Something similar to this:

Select [Column. names] from My Table

In advance thank you

I search for code that extracts column names from a table.

Answer 1

try this,

SELECT  T.Name TableName, C.Name ColumnName 
FROM DatabaseName.sys.tables T
INNER JOIN DatabaseName.sys.Columns C		
ON T.Object_ID  = C.Object_ID 			
WHERE T.Name = 'TableName'

---

Rajesh Jonnalagadda http://www.ggktech.com

Answer 2

Look at INFORMATION_SCHEMA.COLUMNS

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'MyTable'

---

every day is a school day

Answer 3

Tahnk you wery mutch :-)yvind