COL_NAME#
Returns the name of a column from a specified corresponding table identification number and column identification number.
Syntax#
COL_NAME ( table_id , column_id )
Arguments#
table_id
Is the identification number of the table that contains the column. table_id is of type int.
column_id
Is the identification number of the column. column_id parameter is of type int.
Return types#
sysname
Examples#
SELECT COL_NAME(OBJECT_ID('HumanResources.Employee'), 1) AS 'Column Name';