OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Standard Catalogs > Standard Catalog Interface > iiindex_columns Catalog
Was this helpful?
iiindex_columns Catalog
For indexes, any Ingres columns that are defined as part of the primary index key will have 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. This is an object name.
index_owner
char(32)
The index owner. Must be a valid user name.
column_name
char(256)
The name of the column. Must be a valid object name.
key_sequence
integer
Sequence of column within the key, numbered from 1.
sort_direction
char(1)
Defaults to A (ascending).
Last modified date: 01/30/2023