A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iikey_columns Catalog
 
Share this page                  
iikey_columns Catalog
The iikey_columns catalog presents information about the key columns for indexes and base tables not using a heap structure.
Column Name
Data Type
Description
table_name
char(256)
The name of the table key is on
table_owner
char(32)
The owner of the table
column_name
char(256)
Name of key component column
key_sequence
smallint
Position of column in key. 1 being the most significant component
sort_direction
varchar(1)
A: Ascending sort. (Currently only ascending indexes are supported.)