col_name

Syntax

col_name(object_id, column_id [, database_id])

Parameters

• object_id – is a numeric expression that is an object ID for a table, view, or other database object. These are stored in the id column of sysobjects.
• column_id – is a numeric expression that is a column ID of a column. These are stored in the colid column of syscolumns.
• database_id – is a numeric expression that is the ID for a database. These are stored in the db_id column of sysdatabases.

Examples

• Example 1 – Returns the name of the column for table 208003772 and column ID 2:

  select col_name(208003772, 2)

  ------------------------------ 
  title

Usage

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute col_name.