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