Export (0) Print
Expand All
Expand Minimize

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 noteImportant

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).

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft