/** You must have all privillage to access this, else it will denaid access :) **/ SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'tableName';