Lists all columns that participate in an index.
Table 65. SYSCAT.INDEXCOLUSE Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| INDSCHEMA | VARCHAR(128) |
| Qualified name of the index. |
| INDNAME | VARCHAR(18) |
| |
| COLNAME | VARCHAR(128) |
| Name of the column. |
| COLSEQ | SMALLINT |
| Numeric position of the column in the index (initial position = 1). |
| COLORDER | CHAR(1) |
| Order of the values in this column in the index. Values:
|