RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
ForeignKeyColumnsColumns Class
ForeignKeyColumnsColumns Fields | ForeignKeyColumnsColumns Members | Description | See Also
Collapse All

Column names for result table from the built-in stored procedure DB_ADMIN.GET_FOREIGN_KEY_COLUMNS and DataStoreConnection.GetSchema(MetaDataCollectionName.ForeignKeyColumns).

Class Hierarchy
Pascal
ForeignKeyColumnsColumns = class;
C++
class ForeignKeyColumnsColumns;
File

ForeignKeyColumnsColumns.cs

Description

Column names for result table from the built-in stored procedure DB_ADMIN.GET_FOREIGN_KEY_COLUMNS and DataStoreConnection.GetSchema(MetaDataCollectionName.ForeignKeyColumns). 

The columns of the result table are:

Constant 
Description 
CatalogName  
Used to access the CatalogName column in the ForeignKeyColumns metadata collection. The data in this column specifies the catalog name of the table with the foreign key.  
SchemaName  
Used to access the SchemaName column in the ForeignKeyColumns metadata collection. The data in this column specifies the schema name of the table with the foreign key.  
TableName  
Used to access the TableName column in the ForeignKeyColumns metadata collection. The data in this column specifies the name of the table with the foreign key.  
ForeignKeyName  
Used to access the ForeignKeyName column in the ForeignKeyColumns metadata collection. The data in this column specifies the foreign key name.  
ColumnName  
Used to access the ColumnName column in the ForeignKeyColumns metadata collection. The data in this column specifies a column which refers to a column of in another table.  
PrimaryCatalogName  
Used to access the PrimaryCatalogName column in the ForeignKeyColumns metadata collection. The data in this column specifies the catalog name of the table being referred to.  
PrimarySchemaName  
Used to access the PrimarySchemaName column in the ForeignKeyColumns metadata collection. The data in this column specifies the schema name of the table being referred to.  
PrimaryTableName  
Used to access the PrimaryTableName column in the ForeignKeyColumns metadata collection. The data in this column specifies the name of the table being referred to.  
PrimaryKeyName  
Used to access the PrimaryKeyName column in the ForeignKeyColumns metadata collection. The data in this column specifies the name of the key being referred to. This is usually the primary key.  
PrimaryColumnName  
Used to access the PrimaryColumnName column in the ForeignKeyColumns metadata collection. The data in this column specifies the column which is being referred to.  
Ordinal  
Used to access the Ordinal column in the ForeignKeyColumns metadata collection. The data in this column specifies the position of the column reference in the foreign key.  

 

See Also
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!