SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

Built-in Functions (Transact-SQL)

Metadata Functions (Transact-SQL)

@@PROCID (Transact-SQL)

APP_NAME (Transact-SQL)

APPLOCK_MODE (Transact-SQL)

APPLOCK_TEST (Transact-SQL)

ASSEMBLYPROPERTY (Transact-SQL)

COL_LENGTH (Transact-SQL)

COL_NAME (Transact-SQL)

COLUMNPROPERTY (Transact-SQL)

DATABASE_PRINCIPAL_ID (Transact-SQL)

DATABASEPROPERTYEX (Transact-SQL)

DB_ID (Transact-SQL)

DB_NAME (Transact-SQL)

FILE_ID (Transact-SQL)

FILE_IDEX (Transact-SQL)

FILE_NAME (Transact-SQL)

FILEGROUP_ID (Transact-SQL)

FILEGROUP_NAME (Transact-SQL)

FILEGROUPPROPERTY (Transact-SQL)

FILEPROPERTY (Transact-SQL)

FULLTEXTCATALOGPROPERTY (Transact-SQL)

FULLTEXTSERVICEPROPERTY (Transact-SQL)

INDEX_COL (Transact-SQL)

INDEXKEY_PROPERTY (Transact-SQL)

INDEXPROPERTY (Transact-SQL)

NEXT VALUE FOR (Transact-SQL)

OBJECT_DEFINITION (Transact-SQL)

OBJECT_ID (Transact-SQL)

OBJECT_NAME (Transact-SQL)

OBJECT_SCHEMA_NAME (Transact-SQL)

OBJECTPROPERTY (Transact-SQL)

OBJECTPROPERTYEX (Transact-SQL)

ORIGINAL_DB_NAME (Transact-SQL)

PARSENAME (Transact-SQL)

SCHEMA_ID (Transact-SQL)

SCHEMA_NAME (Transact-SQL)

SCOPE_IDENTITY (Transact-SQL)

SERVERPROPERTY (Transact-SQL)

STATS_DATE (Transact-SQL)

TYPE_ID (Transact-SQL)

TYPE_NAME (Transact-SQL)

TYPEPROPERTY (Transact-SQL)

Minimize

0 out of 1 rated this helpful - Rate this topic

Metadata Functions (Transact-SQL)

SQL Server 2012

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

@@PROCID	INDEX_COL
APP_NAME	INDEXKEY_PROPERTY
APPLOCK_MODE	INDEXPROPERTY
APPLOCK_TEST	NEXT VALUE FOR
ASSEMBLYPROPERTY	OBJECT_DEFINITION
COL_LENGTH	OBJECT_ID
COL_NAME	OBJECT_NAME
COLUMNPROPERTY	OBJECT_SCHEMA_NAME
DATABASE_PRINCIPAL_ID	OBJECTPROPERTY
DATABASEPROPERTYEX	OBJECTPROPERTYEX
DB_ID	ORIGINAL_DB_NAME
DB_NAME	PARSENAME
FILE_ID	SCHEMA_ID
FILE_IDEX	SCHEMA_NAME
FILE_NAME	SCOPE_IDENTITY
FILEGROUP_ID	SERVERPROPERTY
FILEGROUP_NAME	STATS_DATE
FILEGROUPPROPERTY	TYPE_ID
FILEPROPERTY	TYPE_NAME
FULLTEXTCATALOGPROPERTY	TYPEPROPERTY
FULLTEXTSERVICEPROPERTY

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.

Reference

Built-in Functions (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.