IndexesColumns Class

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

Class Hierarchy

Pascal

IndexesColumns = class;

C++

class IndexesColumns;

File

IndexesColumns.cs

Description

IndexesColumns provides the column names for the result table from the built-in stored procedure DB_ADMIN.GET_INDEXES and DataStoreConnection.GetSchema(MetaDataCollectionName.IndexColumns). Each row in the result table of DB_ADMIN.GET_INDEXES describes a column in an index in a database.

The columns of the result table are:

Constant	Description
CatalogName	Used to access the CatalogName column in the Indexes metadata collection. The data in this column specifies the catalog name.
SchemaName	Used to access the SchemaName column in the Indexes metadata collection. The data in this column specifies the schema name.
TableName	Used to access the TableName column in the Indexes metadata collection. The data in this column specifies the table name.
IndexName	Used to access the IndexName column in the Indexes metadata collection. The data in this column specifies the index name.
ConstraintName	Used to access the ConstraintName column in the Indexes metadata collection. The data in this column specifies the constraint name, may be NULL.
IsPrimary	Used to access the IsPrimary column in the Indexes metadata collection. The data in this column specifies that the index is the primary key of the table.
IsUnique	Used to access the IsUnique column in the Indexes metadata collection. The data in this column specifies that the index is an unique index of the table.
IsAscending	Used to access the IsAscending column in the Indexes metadata collection. The data in this column specifies that the index is a descending index (Interbase only).