| title | sys.sql_dependencies (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.sql_dependencies (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 06/10/2016 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server]
Contains a row for each dependency on a referenced entity as referenced in the [!INCLUDEtsql] expression or statements that define some other referencing object.
Important
[!INCLUDEssNoteDepFutureAvoid] 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). |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ