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'
Posted by Toniyo Jackson at 3:59 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)