sys-sql-dependencies-transact-sql.md

title	sys.sql_dependencies (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sql_dependencies sql_dependencies_TSQL sys.sql_dependencies_TSQL sys.sql_dependencies
dev_langs	TSQL
helpviewer_keywords	sys.sql_dependencies catalog view
ms.assetid	1779aa87-a0b8-470a-a286-d7cc0b93ad2e
author	stevestein
ms.author	sstein
manager	craigg

sys.sql_dependencies (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains a row for each dependency on a referenced entity as referenced in the [!INCLUDEtsql] expression or statements that define some other referencing object.

Important

[!INCLUDEssNoteDepFutureAvoid] Use sys.sql_expression_dependencies instead.

Column name	Data type	Description
class	tinyint	Identifies the class of the referenced entity: 0 = Object or column (non-schema-bound references only) 1 = Object or column (schema-bound references) 2 = Types (schema-bound references) 3 = XML Schema collections (schema-bound references) 4 = Partition function (schema-bound references)
class_desc	nvarchar(60)	Description of class of referenced entity: OBJECT_OR_COLUMN_REFERENCE_NON_SCHEMA_BOUND OBJECT_OR_COLUMN_REFERENCE_SCHEMA_BOUND TYPE_REFERENCE XML_SCHEMA_COLLECTION_REFERENCE PARTITION_FUNCTION_REFERENCE
object_id	int	ID of the referencing object.
column_id	int	If the referencing ID is a column, ID of referencing column; otherwise, 0.
referenced_major_id	int	ID of the referenced entity, interpreted by value of class, according to: 0, 1 = Object ID of object or column. 2 = Type ID. 3 = XML Schema collection ID.
referenced_minor_id	int	Minor-ID of the referenced entity, interpreted by value of class, as shown in the following. When class =: 0, referenced_minor_id is a column ID; or if not a column, it is 0. 1, referenced_minor_id is a column ID; or if not a column, it is 0. Otherwise, referenced_minor_id = 0.
is_selected	bit	Object or column is selected.
is_updated	bit	Object or column is updated.
is_select_all	bit	Object is used in SELECT * clause (object-level only).

Permissions

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

See Also

Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ