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 87. OBJCAT.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). |
| ORIGIN_TABSCHEMA | CHAR(8) |
| Qualified name of the table in the table hierarchy where the key was introduced. |
| ORIGIN_TABNAME | VARCHAR(18) |
|