SYS_KEY_COLUMN_USAGE maps columns to key constraints.
| Column name | Data type | Description |
|---|---|---|
CONSTRAINT_CATALOG |
VARCHAR(128) |
A top-level container for constraints. Not used. Always NULL. |
CONSTRAINT_SCHEMA |
VARCHAR(128) |
A second-level container for constraints. Not used. Always NULL. |
CONSTRAINT_NAME |
VARCHAR(128) |
The name of the constraint. |
TABLE_CATALOG |
VARCHAR(128) |
A top-level container for tables. Not used. Always NULL. |
TABLE_SCHEMA |
VARCHAR(128) |
A second-level container for tables. Not used. Always NULL. |
TABLE_NAME |
VARCHAR(128) |
The name of the object to which the field belongs. |
COLUMN_NAME |
VARCHAR(128) |
The name of the object field. |
ORDINAL_POSITION |
INT |
The position of the field in the key. |