sys.sql_dependencies (Transact-SQL)

Contains a row for each dependency on a referenced entity as referenced in the Transact-SQL expression or statements that define some other referencing object.

Important

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.