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

See Also