602SQL Documentation Index  

_IV_INDICIES System Query

The system query _iv_indicies returns a list of table indexes.

The result of this query may be very complex. It is recommended to use this only inside of another query that specifies the desired constraints for the column values.

Column description

Column name Type Contents
Schema_name CHAR(31) Name of the schema the table belongs
Table_name CHAR(31) Name of the table
Constrain_name CHAR(31) Name of the index
Index_type SMALLINT Index type (1=primary key, 2=unique, 3=nonunique)
Definition CLOB Index definition (a column, list of columns or expressions)
Has_nulls BOOLEAN Contains NULL values?

Example

Find all indexes on a table:

SELECT * FROM _iv_indicies WHERE table_name='CUSTOMERS'