funções de metadados (Transact-SQL)Metadata Functions (Transact-SQL)

APLICA-SE A: simSQL Server (a partir do 2012) nãoBanco de Dados SQL do Azure nãoSQL Data Warehouse do Azure nãoParallel Data Warehouse APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

As seguintes funções escalares retornam informações sobre o banco de dados e seus objetos:The following scalar functions return information about the database and database objects:

@@PROCID@@PROCID INDEX_COLINDEX_COL
APP_NAMEAPP_NAME INDEXKEY_PROPERTYINDEXKEY_PROPERTY
APPLOCK_MODEAPPLOCK_MODE INDEXPROPERTYINDEXPROPERTY
APPLOCK_TESTAPPLOCK_TEST NEXT VALUE FORNEXT VALUE FOR
ASSEMBLYPROPERTYASSEMBLYPROPERTY OBJECT_DEFINITIONOBJECT_DEFINITION
COL_LENGTHCOL_LENGTH OBJECT_IDOBJECT_ID
COL_NAMECOL_NAME OBJECT_NAMEOBJECT_NAME
COLUMNPROPERTYCOLUMNPROPERTY OBJECT_SCHEMA_NAMEOBJECT_SCHEMA_NAME
DATABASE_PRINCIPAL_IDDATABASE_PRINCIPAL_ID OBJECTPROPERTYOBJECTPROPERTY
DATABASEPROPERTYEXDATABASEPROPERTYEX OBJECTPROPERTYEXOBJECTPROPERTYEX
DB_IDDB_ID ORIGINAL_DB_NAMEORIGINAL_DB_NAME
DB_NAMEDB_NAME PARSENAMEPARSENAME
FILE_IDFILE_ID SCHEMA_IDSCHEMA_ID
FILE_IDEXFILE_IDEX SCHEMA_NAMESCHEMA_NAME
FILE_NAMEFILE_NAME SCOPE_IDENTITYSCOPE_IDENTITY
FILEGROUP_IDFILEGROUP_ID SERVERPROPERTYSERVERPROPERTY
FILEGROUP_NAMEFILEGROUP_NAME STATS_DATESTATS_DATE
FILEGROUPPROPERTYFILEGROUPPROPERTY TYPE_IDTYPE_ID
FILEPROPERTYFILEPROPERTY TYPE_NAMETYPE_NAME
FULLTEXTCATALOGPROPERTYFULLTEXTCATALOGPROPERTY TYPEPROPERTYTYPEPROPERTY
FULLTEXTSERVICEPROPERTYFULLTEXTSERVICEPROPERTY VERSIONVERSION

Todas as funções de metadados são não determinísticas.All metadata functions are nondeterministic. Isso significa que essas funções nem sempre retornam os mesmos resultados a cada chamada, mesmo com o mesmo conjunto de valores de entrada.This means these functions do not always return the same results every time they are called, even with the same set of input values.

Consulte TambémSee Also

Funções internas (Transact-SQL)Built-in Functions (Transact-SQL)