Data.DBXMetaDataNames.TDBXForeignKeyColumnsIndex
Delphi
TDBXForeignKeyColumnsIndex = class
C++
class PASCALIMPLEMENTATION TDBXForeignKeyColumnsIndex : public System::TObject
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | Data.DBXMetaDataNames.pas Data.DBXMetaDataNames.hpp |
Data.DBXMetaDataNames | Data.DBXMetaDataNames |
Description
Accesses columns by ordinal in the ForeignKeyColumns metadata.
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. |