SYSKEYS catalog table
The SYSKEYS table contains one row for each column of an index key. The schema is SYSIBM.
Column name | Data type | Description | Use |
---|---|---|---|
IXNAME | VARCHAR(128)
NOT NULL |
Name of the index. | G |
IXCREATOR | VARCHAR(128)
NOT NULL |
Schema or qualifier of the index. | G |
COLNAME | VARCHAR(128)
NOT NULL |
Name of the column of the key. | G |
COLNO | SMALLINT
NOT NULL |
Numeric position of the column in the table. For example, 4 (out of 10). | G |
COLSEQ | SMALLINT
NOT NULL |
Numeric position of the column in the key for an index on columns. For example, 4 (out of 4). The value is meaningless for an expression-based index. | G |
ORDERING | CHAR(1)
NOT NULL |
Order of the column in the key:
|
G |
IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
PERIOD | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates whether the column is the start or end
column for the BUSINESS_TIME period:
|
G |
CREATEDTS |
TIMESTAMP(12)
NOT NULL WITH DEFAULT |
Time when the CREATE statement was executed for the index. | G |