MetaDataCollectionName.ForeignKeyColumns Field

This metadata collection represents foreign key columns in a database.

Pascal

const ForeignKeyColumns: string = "ForeignKeyColumns";

C++

string ForeignKeyColumns = "ForeignKeyColumns";

This metadata collection represents foreign key columns in a database.

The columns are:

Column Name	Data Type	Description
CatalogName	String	The catalog name.
SchemaName	String	The schema name of the table with the foreign key.
TableName	String	The table name of the table with the foreign key.
ForeignKeyName	String	The foreign key name.
ColumnName	String	A column which refers to a column of in another table.
PrimaryCatalogName	String	The catalog name of the table being referred to.
PrimarySchemaName	String	The schema name of the table being referred to.
PrimaryTableName	String	The name of the table being referred to.
PrimaryKeyName	String	The name of the key being referred to. This is usually the primary key.
PrimaryColumnName	String	The column which is being referred to.
Ordinal	Int32	The position of the column reference in the foreign key.