Thursday, December 9, 2010

Query to get All Column names of a table in Sql server

Solution

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'tablename'

No comments: