SYSCAT.KEYCOLUSE catalog view
Each row represents a column that participates in a key defined by a unique, primary key, or foreign key constraint.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| CONSTNAME | VARCHAR (128) | Name of the constraint. | |
| TABSCHEMA | VARCHAR (128) | Schema name of the table containing the column. | |
| TABNAME | VARCHAR (128) | Unqualified name of the table containing the column. | |
| COLNAME | VARCHAR (128) | Name of the column. | |
| COLSEQ | SMALLINT | Numeric position of the column in the key for the constraint (initial position is 1). If a constraint uses an existing index, this value is the numeric position of the column in the index. |