By the following query you will get column name of table in current database.
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME = ‘Table_Name’
Posted by gobinmuthu on October 18, 2012 in SQL
Δ