How To View Column Names For A Table In T-SQL

Posted February 4, 2010

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '<TABLE NAME>'
ORDER BY ORDINAL_POSITION

No Comment