INFORMATION_SCHEMA.columns

Determining column names and data types of a table

The column names and their data types can be determined with the columns view in in INFORMATION_SCHEMA:

select
   col.column_name,
   col.data_type,
   col.is_nullable
from
   information_schema.columns col
where
-- col.table_catalog = 'xyz'      and
-- col.table_schema  = 'xyz'      and
   col.table_name    = 'TQ84_CPG'
order by
   col.ordinal_position;

Github repository about-MSSQL, path: /administration/schemas/INFORMATION_SCHEMA/columns/select-datatypes.sql

An alternative way is to use the stored procedure sp_columns.

INFORMATION_SCHEMA.columns

Determining column names and data types of a table

See also