TDBXForeignKeyColumnsIndex Class

Accesses columns by ordinal in the ForeignKeyColumns metadata.

Pascal

TDBXForeignKeyColumnsIndex = class;

C++

class TDBXForeignKeyColumnsIndex;

File

DBXMetaDataNames

Description

TDBXForeignKeyColumnsIndex is used to access columns by ordinal in the ForeignKeyColumns metadata collection. These columns are returned when TDBXCommand.Text is TDBXMetaDataCommands.GetForeignKeyColumns when reading metadata. To retrieve metadata columns, use these constants to index the TDBXReader instance returned by TDBXCommand.ExecuteQuery.

This table describes the columns.

Column Ordinal Name	Data Type of Column Data	Description
CatalogName	String	Catalog name of table with foreign key.
SchemaName	String	Schema name of table with foreign key.
TableName	String	Table name of table with foreign key.
ForeignKeyName	String	Foreign key name.
ColumnName	String	Column that refers to a column in another table.
PrimaryCatalogName	String	Catalog name of table being referred to.
PrimarySchemaName	String	Schema name of table being referred to.
PrimaryTableName	String	Name of table being referred to.
PrimaryKeyName	String	Name of key being referred to. This is usually the primary key.
PrimaryColumnName	String	Column being referred to.
Ordinal	Int32	Position of column reference in foreign key.