sys.sql_dependencies (Transact-SQL)

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.

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.

See Also

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