Table of Contents

Class CompatibilitySchema.Reference

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

sys.sysreferences (Transact-SQL)

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

Contains mappings of the FOREIGN KEY constraint definitions to the referenced columns within the database.

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.sysreferences.

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

Properties

ConstraintID

ID of the FOREIGN KEY constraint.

[Column("constid")]
[NotNull]
public int ConstraintID { get; set; }

Property Value

int

FKeyID

ID of the referencing table.

[Column("fkeyid")]
[NotNull]
public int FKeyID { get; set; }

Property Value

int

Fkey1

Column ID of the referencing column.

[Column("fkey1")]
[Nullable]
public short? Fkey1 { get; set; }

Property Value

short?

Fkey10

Column ID of the referencing column.

[Column("fkey10")]
[Nullable]
public short? Fkey10 { get; set; }

Property Value

short?

Fkey11

Column ID of the referencing column.

[Column("fkey11")]
[Nullable]
public short? Fkey11 { get; set; }

Property Value

short?

Fkey12

Column ID of the referencing column.

[Column("fkey12")]
[Nullable]
public short? Fkey12 { get; set; }

Property Value

short?

Fkey13

Column ID of the referencing column.

[Column("fkey13")]
[Nullable]
public short? Fkey13 { get; set; }

Property Value

short?

Fkey14

Column ID of the referencing column.

[Column("fkey14")]
[Nullable]
public short? Fkey14 { get; set; }

Property Value

short?

Fkey15

Column ID of the referencing column.

[Column("fkey15")]
[Nullable]
public short? Fkey15 { get; set; }

Property Value

short?

Fkey16

Column ID of the referencing column.

[Column("fkey16")]
[Nullable]
public short? Fkey16 { get; set; }

Property Value

short?

Fkey2

Column ID of the referencing column.

[Column("fkey2")]
[Nullable]
public short? Fkey2 { get; set; }

Property Value

short?

Fkey3

Column ID of the referencing column.

[Column("fkey3")]
[Nullable]
public short? Fkey3 { get; set; }

Property Value

short?

Fkey4

Column ID of the referencing column.

[Column("fkey4")]
[Nullable]
public short? Fkey4 { get; set; }

Property Value

short?

Fkey5

Column ID of the referencing column.

[Column("fkey5")]
[Nullable]
public short? Fkey5 { get; set; }

Property Value

short?

Fkey6

Column ID of the referencing column.

[Column("fkey6")]
[Nullable]
public short? Fkey6 { get; set; }

Property Value

short?

Fkey7

Column ID of the referencing column.

[Column("fkey7")]
[Nullable]
public short? Fkey7 { get; set; }

Property Value

short?

Fkey8

Column ID of the referencing column.

[Column("fkey8")]
[Nullable]
public short? Fkey8 { get; set; }

Property Value

short?

Fkey9

Column ID of the referencing column.

[Column("fkey9")]
[Nullable]
public short? Fkey9 { get; set; }

Property Value

short?

FkeyDbID

Reserved.

[Column("fkeydbid")]
[Nullable]
public short? FkeyDbID { get; set; }

Property Value

short?

Forkeys

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

[Column("forkeys")]
[Nullable]
public byte[]? Forkeys { get; set; }

Property Value

byte[]

KeyCnt

Number of columns in the key.

[Column("keycnt")]
[Nullable]
public short? KeyCnt { get; set; }

Property Value

short?

RKeyID

ID of the referenced table.

[Column("rkeyid")]
[Nullable]
public int? RKeyID { get; set; }

Property Value

int?

Refkeys

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

[Column("refkeys")]
[Nullable]
public byte[]? Refkeys { get; set; }

Property Value

byte[]

Rkey1

Column ID of the referenced column.

[Column("rkey1")]
[Nullable]
public short? Rkey1 { get; set; }

Property Value

short?

Rkey10

Column ID of the referenced column.

[Column("rkey10")]
[Nullable]
public short? Rkey10 { get; set; }

Property Value

short?

Rkey11

Column ID of the referenced column.

[Column("rkey11")]
[Nullable]
public short? Rkey11 { get; set; }

Property Value

short?

Rkey12

Column ID of the referenced column.

[Column("rkey12")]
[Nullable]
public short? Rkey12 { get; set; }

Property Value

short?

Rkey13

Column ID of the referenced column.

[Column("rkey13")]
[Nullable]
public short? Rkey13 { get; set; }

Property Value

short?

Rkey14

Column ID of the referenced column.

[Column("rkey14")]
[Nullable]
public short? Rkey14 { get; set; }

Property Value

short?

Rkey15

Column ID of the referenced column.

[Column("rkey15")]
[Nullable]
public short? Rkey15 { get; set; }

Property Value

short?

Rkey16

Column ID of the referenced column.

[Column("rkey16")]
[Nullable]
public short? Rkey16 { get; set; }

Property Value

short?

Rkey2

Column ID of the referenced column.

[Column("rkey2")]
[Nullable]
public short? Rkey2 { get; set; }

Property Value

short?

Rkey3

Column ID of the referenced column.

[Column("rkey3")]
[Nullable]
public short? Rkey3 { get; set; }

Property Value

short?

Rkey4

Column ID of the referenced column.

[Column("rkey4")]
[Nullable]
public short? Rkey4 { get; set; }

Property Value

short?

Rkey5

Column ID of the referenced column.

[Column("rkey5")]
[Nullable]
public short? Rkey5 { get; set; }

Property Value

short?

Rkey6

Column ID of the referenced column.

[Column("rkey6")]
[Nullable]
public short? Rkey6 { get; set; }

Property Value

short?

Rkey7

Column ID of the referenced column.

[Column("rkey7")]
[Nullable]
public short? Rkey7 { get; set; }

Property Value

short?

Rkey8

Column ID of the referenced column.

[Column("rkey8")]
[Nullable]
public short? Rkey8 { get; set; }

Property Value

short?

Rkey9

Column ID of the referenced column.

[Column("rkey9")]
[Nullable]
public short? Rkey9 { get; set; }

Property Value

short?

RkeyDbID

Reserved.

[Column("rkeydbid")]
[Nullable]
public short? RkeyDbID { get; set; }

Property Value

short?

Rkeyindid

Index ID of the unique index on the referenced table covering the referenced key-columns.

[Column("rkeyindid")]
[Nullable]
public short? Rkeyindid { get; set; }

Property Value

short?