SYSCAT.INDEXCOLUSE catalog view
Each row represents a column that participates in an index.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
INDSCHEMA | VARCHAR (128) | Schema name of the index. | |
INDNAME | VARCHAR (128) | Unqualified name of the index. | |
COLNAME | VARCHAR (128) | Name of the column. | |
COLSEQ | SMALLINT | Numeric position of the column in the index (initial position is 1). | |
COLORDER | CHAR (1) | Order of the values in this index column. Possible values are:
|
|
COLLATIONSCHEMA | VARCHAR (128) | Y | For string types, the schema name of the collation for the column; the null value otherwise. |
COLLATIONNAME | VARCHAR (128) | Y | For string types, the unqualified name of the collation for the column; the null value otherwise. |
VIRTUAL | CHAR (1) | Y |
|
TEXT | CLOB (64K) | Y | The expression text for this part of the index key. The null value if this part of the index key is not based on an expression. |