Tag Archives: T-SQL
How To View Column Names For A Table In T-SQL
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘<TABLE NAME>’ ORDER BY ORDINAL_POSITION
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘<TABLE NAME>’ ORDER BY ORDINAL_POSITION