Select Column List from Table

by Ravi Tuvar 2:17 AM 0 comments

SELECT 

   Column_Name

    FROM 

        INFORMATION_SCHEMA.COLUMNS

    WHERE 

        TABLE_CATALOG = 'DataBase Name' 

        AND TABLE_SCHEMA = 'DBO Schema Name'

   :     AND TABLE_NAME = 'Table Name'