| title | Metadata Functions (Transact-SQL) | ||
|---|---|---|---|
| description | Metadata Functions (Transact-SQL) | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | |||
| ms.date | 06/10/2016 | ||
| ms.prod | sql | ||
| ms.prod_service | sql-database | ||
| ms.technology | t-sql | ||
| ms.topic | reference | ||
| ms.custom | |||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE 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.