Table of Contents

Class ObjectSchema.SqlDependency

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.sql_dependencies (Transact-SQL)

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.


See sys.sql_dependencies.

[Table(Schema = "sys", Name = "sql_dependencies", IsView = true)]
public class ObjectSchema.SqlDependency
Inheritance
ObjectSchema.SqlDependency
Inherited Members
Extension Methods

Properties

Class

class NOT NULL 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) 
[Column("class")]
[NotNull]
public byte Class { get; set; }

Property Value

byte

ClassDesc

class_desc NULL 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 
[Column("class_desc")]
[Nullable]
public string? ClassDesc { get; set; }

Property Value

string

ColumnID

column_id NOT NULL int

If the referencing ID is a column, ID of referencing column; otherwise, 0. 
[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

IsSelectAll

is_select_all NOT NULL bit

Object is used in SELECT * clause (object-level only). 
[Column("is_select_all")]
[NotNull]
public bool IsSelectAll { get; set; }

Property Value

bool

IsSelected

is_selected NOT NULL bit

Object or column is selected. 
[Column("is_selected")]
[NotNull]
public bool IsSelected { get; set; }

Property Value

bool

IsUpdated

is_updated NOT NULL bit

Object or column is updated. 
[Column("is_updated")]
[NotNull]
public bool IsUpdated { get; set; }

Property Value

bool

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL int

ID of the referencing object. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ReferencedMajorID

referenced_major_id NOT NULL 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. 
[Column("referenced_major_id")]
[NotNull]
public int ReferencedMajorID { get; set; }

Property Value

int

ReferencedMinorID

referenced_minor_id NOT NULL 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. 
[Column("referenced_minor_id")]
[NotNull]
public int ReferencedMinorID { get; set; }

Property Value

int