DbForeignKeyInfo

DbForeignKeyInfo

public DbForeignKeyInfo(string ConstraintName, string TableName, string ColumnName, string RefTableName, string RefColumnName)

dbForeignKeyInfo = DbForeignKeyInfo(ConstraintName, TableName, ColumnName, RefTableName, RefColumnName)

Represents a single foreign-key constraint discovered in a live database via CancellationToken). Compound foreign keys are surfaced as multiple rows — one per referencing/referenced column pair.

ConstraintName

Name of the FOREIGN KEY constraint as stored by the database.

TableName

Name of the table that holds the FK column.

ColumnName

Name of the column constrained by this FK.

RefTableName

Name of the referenced (parent) table.

RefColumnName

Name of the referenced column on the parent table.

ColumnName

public string ColumnName { get; set; }

value = dbForeignKeyInfo.ColumnName
dbForeignKeyInfo.ColumnName = value

Name of the column constrained by this FK.

ConstraintName

public string ConstraintName { get; set; }

value = dbForeignKeyInfo.ConstraintName
dbForeignKeyInfo.ConstraintName = value

Name of the FOREIGN KEY constraint as stored by the database.

RefColumnName

public string RefColumnName { get; set; }

value = dbForeignKeyInfo.RefColumnName
dbForeignKeyInfo.RefColumnName = value

Name of the referenced column on the parent table.

RefTableName

public string RefTableName { get; set; }

value = dbForeignKeyInfo.RefTableName
dbForeignKeyInfo.RefTableName = value

Name of the referenced (parent) table.

TableName

public string TableName { get; set; }

value = dbForeignKeyInfo.TableName
dbForeignKeyInfo.TableName = value

Name of the table that holds the FK column.