metadata-functions-transact-sql.md

title	Metadata Functions (Transact-SQL)
description	Metadata Functions (Transact-SQL)
author	markingmyname
ms.author	maghan
ms.date	06/10/2016
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
helpviewer_keywords	metadata [SQL Server], functions functions [SQL Server], metadata
dev_langs	TSQL

Metadata Functions (Transact-SQL)

[!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.

See Also

Built-in Functions (Transact-SQL)