Lists all columns that participate in a key (including inherited primary or
unique keys where applicable) defined by a unique, primary key, or foreign key
constraint.
Table 69. SYSCAT.KEYCOLUSE Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| CONSTNAME | VARCHAR(18) |
| Name of the constraint (unique within a table). |
| TABSCHEMA | VARCHAR(128) |
| Qualified name of the table containing the column. |
| TABNAME | VARCHAR(128) |
| |
| COLNAME | VARCHAR(128) |
| Name of the column. |
| COLSEQ | SMALLINT |
| Numeric position of the column in the key (initial position=1). |