Class ObjectSchema.ForeignKeyColumn

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.foreign_key_columns (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Contains a row for each column, or set of columns, that comprise a foreign key.

See sys.foreign_key_columns.

[Table(Schema = "sys", Name = "foreign_key_columns", IsView = true)]
public class ObjectSchema.ForeignKeyColumn

Inheritance

object

ObjectSchema.ForeignKeyColumn

Extension Methods

Map.DeepCopy<T>(T)

Properties

ConstraintColumnID

ID of the column, or set of columns, that comprise the FOREIGN KEY (1..n where n=number of columns).

[Column("constraint_column_id")]
[NotNull]
public int ConstraintColumnID { get; set; }

Property Value

int

ConstraintObjectID

ID of the FOREIGN KEY constraint.

[Column("constraint_object_id")]
[NotNull]
public int ConstraintObjectID { get; set; }

Property Value

int

ParentColumnID

ID of the parent column, which is the referencing column.

[Column("parent_column_id")]
[NotNull]
public int ParentColumnID { get; set; }

Property Value

int

ParentObjectID

ID of the parent of the constraint, which is the referencing object.

[Column("parent_object_id")]
[NotNull]
public int ParentObjectID { get; set; }

Property Value

int

ReferencedColumnID

ID of the referenced column (candidate key column).

[Column("referenced_column_id")]
[NotNull]
public int ReferencedColumnID { get; set; }

Property Value

int

ReferencedObjectID

ID of the referenced object, which has the candidate key.

[Column("referenced_object_id")]
[NotNull]
public int ReferencedObjectID { get; set; }

Property Value

int