Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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