Meta Data Functions

These scalar functions return information about the database and database objects.

COL_LENGTH	fn_listextendedproperty
COL_NAME	FULLTEXTCATALOGPROPERTY
COLUMNPROPERTY	FULLTEXTSERVICEPROPERTY
DATABASEPROPERTY	INDEX_COL
DATABASEPROPERTYEX	INDEXKEY_PROPERTY
DB_ID	INDEXPROPERTY
DB_NAME	OBJECT_ID
FILE_ID	OBJECT_NAME
FILE_NAME	OBJECTPROPERTY
FILEGROUP_ID	@@PROCID
FILEGROUP_NAME	SQL_VARIANT_PROPERTY
FILEGROUPPROPERTY	TYPEPROPERTY
FILEPROPERTY

All meta data functions are nondeterministic.  They do not always return the same results every time they are called with a specific set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

See Also

Functions