A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iiindex_columns Catalog
 
Share this page                  
iiindex_columns Catalog
For indexes, any columns that are defined as part of the primary index key has an entry in iiindex_columns. For a full list of all columns in the index, use the iicolumns catalog.
Column Name
Data Type
Description
index_name
char(256)
The index containing column_name
index_owner
char(32)
The name of the index owner
column_name
char(256)
The name of the column
key_sequence
smallint
Sequence of column in the key, numbered from 1
sort_direction
char(1)
Defaults to A for ascending