Export (0) Print
Expand All
7 out of 8 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.