TDBXForeignKeyColumnsColumns Class

Accesses columns by name in the ForeignKeyColumns metadata.

Pascal

TDBXForeignKeyColumnsColumns = class;

C++

class TDBXForeignKeyColumnsColumns;

File

DBXMetaDataNames

Description

TDBXForeignKeyColumnsColumns is used to access columns by name 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 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.