How to get column names from Sql Server table

Shiji Pan

12 years ago

SELECT [name] AS [Column Name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = ‘U’ AND [Name] = ‘My_Table_Name’)

Type = ‘V’ for views Type = ‘U’ for tables

For SQL Server 2008, we can use information_schema.columns for getting column information:

SELECT * FROM information_schema.columns WHERE table_name = ‘My_Table_Name’ ORDER BY ordinal_position