sys.sql_dependencies (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

System_CAPS_ICON_important.jpg 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 nameData typeDescription
classtinyintIdentifies 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_descnvarchar(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_idintID of the referencing object.
column_idintIf the referencing ID is a column, ID of referencing column; otherwise, 0.
referenced_major_idintID 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_idintMinor-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_selectedbitObject or column is selected.
is_updatedbitObject or column is updated.
is_select_allbitObject is used in SELECT * clause (object-level only).

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

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

Community Additions

ADD
Show: