_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'
