Table of Contents

Class CompatibilitySchema.Depend

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

sys.sysdepends (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains dependency information between objects (views, procedures, and triggers) in the database, and the objects (tables, views, and procedures) that are contained in their definition.

important


This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). 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.


See sys.sysdepends.

[Table(Schema = "sys", Name = "sysdepends", IsView = true)]
public class CompatibilitySchema.Depend
Inheritance
CompatibilitySchema.Depend
Extension Methods

Properties

DepDbID

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("depdbid")]
[Nullable]
public short? DepDbID { get; set; }

Property Value

short?

DepID

Dependent object ID.

[Column("depid")]
[NotNull]
public int DepID { get; set; }

Property Value

int

DepNumber

Dependent procedure number.

[Column("depnumber")]
[Nullable]
public short? DepNumber { get; set; }

Property Value

short?

DepSiteID

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("depsiteid")]
[Nullable]
public short? DepSiteID { get; set; }

Property Value

short?

DepType

Identifies the dependent object type:

0 = Object or column (non-schema-bound references only

1 = Object or column (schema-bound references)

[Column("deptype")]
[NotNull]
public byte DepType { get; set; }

Property Value

byte

ID

Object ID.

[Column("id")]
[NotNull]
public int ID { get; set; }

Property Value

int

Number

Procedure number.

[Column("number")]
[Nullable]
public short? Number { get; set; }

Property Value

short?

ReadObj

1 = The object is being read.

0 = No.

[Column("readobj")]
[NotNull]
public bool ReadObj { get; set; }

Property Value

bool

ResultObj

1 = Object is being updated.

0 = No.

[Column("resultobj")]
[NotNull]
public bool ResultObj { get; set; }

Property Value

bool

SelectAll

1 = Object is used in a SELECT * statement.

0 = No.

[Column("selall")]
[NotNull]
public bool SelectAll { get; set; }

Property Value

bool

Status

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("status")]
[Nullable]
public short? Status { get; set; }

Property Value

short?