Object Catalog Views (Trans ...


SQL Server 2008 Books Online (October 2009)
sys.sql_dependencies (Transact-SQL)

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.

ms174402.note(en-us,SQL.100).gifImportant:
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

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

See Also

Reference

Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)

Other Resources

Implementing User-defined Types
Understanding SQL Dependencies
Querying the SQL Server System Catalog FAQ

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker