Select Column List from Table

by Ravi Tuvar 4:52 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'