RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
IndexColumnsColumns Class

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

Pascal
IndexColumnsColumns = class;
C++
class IndexColumnsColumns;

IndexColumnsColumns.cs

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

The columns of the result table are:

Constant 
Description 
Used to access the CatalogName column in the IndexColumns metadata collection. The data in this column specifies the catalog name.  
Used to access the SchemaName column in the IndexColumns metadata collection. The data in this column specifies the schema name.  
Used to access the TableName column in the IndexColumns metadata collection. The data in this column specifies the table name.  
Used to access the IndexName column in the IndexColumns metadata collection. data in this column specifies the index name.  
Used to access the ColumnName column in the IndexColumns metadata collection. The data in this column specifies a column in the index.  
Used to access the Ordinal column in the IndexColumns metadata collection. The data in this column specifies the position of the column in the index starting with 1.  
Used to access the IsAscending column in the IndexColumns metadata collection. The data in this column specifies that the index column is a descending index column.  

 

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