Metadata Functions (Transact-SQL)

The following scalar functions return information about the database and database objects:

@@PROCID

INDEX_COL

APP_NAME

INDEXKEY_PROPERTY

APPLOCK_MODE

INDEXPROPERTY

APPLOCK_TEST

NEXT VALUE FOR

ASSEMBLYPROPERTY

OBJECT_DEFINITION

COL_LENGTH

OBJECT_ID

COL_NAME

OBJECT_NAME

COLUMNPROPERTY

OBJECT_SCHEMA_NAME

DATABASE_PRINCIPAL_ID

OBJECTPROPERTY

DATABASEPROPERTYEX

OBJECTPROPERTYEX

DB_ID

ORIGINAL_DB_NAME

DB_NAME

PARSENAME

FILE_ID

SCHEMA_ID

FILE_IDEX

SCHEMA_NAME

FILE_NAME

SCOPE_IDENTITY

FILEGROUP_ID

SERVERPROPERTY

FILEGROUP_NAME

STATS_DATE

FILEGROUPPROPERTY

TYPE_ID

FILEPROPERTY

TYPE_NAME

FULLTEXTCATALOGPROPERTY

TYPEPROPERTY

FULLTEXTSERVICEPROPERTY

All metadata functions are nondeterministic. This means these functions do not always return the same results every time they are called, even with the same set of input values.

See Also

Reference

Built-in Functions (Transact-SQL)