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