The HSSYSKEY table is used for SYSKEY views. The following table describes the columns in the HSSYSKEY table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| IXNAME | VARCHAR | 128 | 0 | Name of the index |
| IXCREATOR | VARCHAR | 128 | 0 | Schema or qualifier of the index |
| COLNAME | VARCHAR | 128 | 0 | Name of the column of the key |
| COLNO | SMALLINT | 4 | 0 | Numeric position of the column in the table |
| COLSEQ | SMALLINT | 4 | 0 | Numeric position of the column in the key for an index on columns |
| ORDERING | CHAR | 1 | 0 | Order of the column in the key |
| IBMREQD | CHAR | 1 | 0 |