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

Posted on February 4, 2010 by admin

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

About admin

Freelance Web Developer C# .NET, PHP5 Zend Framework, Flex/Actionscript

This entry was posted in Programming and tagged T-SQL. Bookmark the permalink.