Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
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.
Applies to: SQL Server (SQL Server 2008 through current version).
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)
Description of class of referenced entity:
ID of the referencing object.
If the referencing ID is a column, ID of referencing column; otherwise, 0.
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.
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.
Object or column is selected.
Object or column is updated.
Object is used in SELECT * clause (object-level only).
Requires membership in the public role. For more information, see Metadata Visibility Configuration.