Metadata Functions (Transact-SQL)

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

@@PROCID	fn_listextendedproperty
ASSEMBLYPROPERTY	FULLTEXTCATALOGPROPERTY
COL_LENGTH	FULLTEXTSERVICEPROPERTY
COL_NAME	INDEX_COL
COLUMNPROPERTY	INDEXKEY_PROPERTY
DATABASEPROPERTY	INDEXPROPERTY
DATABASEPROPERTYEX	OBJECT_ID
DB_ID	OBJECT_NAME
DB_NAME	OBJECTPROPERTY
FILE_ID	OBJECTPROPERTYEX
FILE_IDEX	SCHEMA_ID
FILE_NAME	SCHEMA_NAME
FILEGROUP_ID	SQL_VARIANT_PROPERTY
FILEGROUP_NAME	TYPE_ID
FILEGROUPPROPERTY	TYPE_NAME
FILEPROPERTY	TYPEPROPERTY

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. For more information about function determinism, see Deterministic and Nondeterministic Functions.

See Also

Reference

Functions (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance