Class ObjectSchema.SqlDependency
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.sql_dependencies (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
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.
See sys.sql_dependencies.
[Table(Schema = "sys", Name = "sql_dependencies", IsView = true)]
public class ObjectSchema.SqlDependency- Inheritance
-
ObjectSchema.SqlDependency
- Extension Methods
Properties
Class
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
ClassDesc
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
ColumnID
If the referencing ID is a column, ID of referencing column; otherwise, 0.
[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }Property Value
IsSelectAll
Object is used in SELECT * clause (object-level only).
[Column("is_select_all")]
[NotNull]
public bool IsSelectAll { get; set; }Property Value
IsSelected
Object or column is selected.
[Column("is_selected")]
[NotNull]
public bool IsSelected { get; set; }Property Value
IsUpdated
Object or column is updated.
[Column("is_updated")]
[NotNull]
public bool IsUpdated { get; set; }Property Value
Object
objects (sys.objects)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }Property Value
ObjectID
ID of the referencing object.
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }Property Value
ReferencedMajorID
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
ReferencedMinorID
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; }