sys.sql_dependencies (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
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 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