Metadata Functions (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

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

• @@PROCID
• APP_NAME
• APPLOCK_MODE
• APPLOCK_TEST
• ASSEMBLYPROPERTY
• COL_LENGTH
• COL_NAME
• COLUMNPROPERTY
• DATABASE_PRINCIPAL_ID
• DATABASEPROPERTYEX
• DB_ID
• DB_NAME
• FILE_ID
• FILE_IDEX
• FILE_NAME
• FILEGROUP_ID
• FILEGROUP_NAME
• FILEGROUPPROPERTY
• FILEPROPERTY
• FULLTEXTCATALOGPROPERTY
• FULLTEXTSERVICEPROPERTY
• INDEX_COL
• INDEXKEY_PROPERTY
• INDEXPROPERTY
• NEXT VALUE FOR
• OBJECT_DEFINITION
• OBJECT_ID
• OBJECT_NAME
• OBJECT_SCHEMA_NAME
• OBJECTPROPERTY
• OBJECTPROPERTYEX
• ORIGINAL_DB_NAME
• PARSENAME
• SCHEMA_ID
• SCHEMA_NAME
• SCOPE_IDENTITY
• SERVERPROPERTY
• STATS_DATE
• TYPE_ID
• TYPE_NAME
• TYPEPROPERTY
• VERSION

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

Built-in Functions (Transact-SQL)