C. Standard Catalog Interface : Catalogs : The iialt_columns Catalog
 
Share this page                  
The iialt_columns Catalog
For each alternate key, any columns defined as part of the key have an entry in iialt_columns.
Column Name
Data Type
Description
table_name
char(256)
The table to which column_name belongs
table_owner
char(32)
The table owner
key_id
integer
The number of the alternate key for this table
column_name
char(256)
The name of the column
key_sequence
smallint
Sequence of column within the key, numbered from 1