Kommentar
Å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.
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.
See Also
Reference
Object Catalog Views (Transact-SQL)