| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sql_dependencies (Transact-SQL) |
sys.sql_dependencies (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!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