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

Meta Data Functions

SQL Server 2000

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.