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';