This system table contains information about referenced table columns of all constraints of the database.
Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
| Column Name | Description |
|---|---|
CONSTRAINT_SCHEMA
|
Associated schema |
CONSTRAINT_TABLE
|
Associated table |
CONSTRAINT_TYPE
|
Constraint type (PRIMARY KEY, FOREIGN KEY or NOT
NULL) |
CONSTRAINT_NAME
|
Name of the constraint |
CONSTRAINT_OWNER
|
Owner of the constraint (which is the owner of the table) |
ORDINAL_POSITION
|
Position of the column in the table beginning at 1 |
COLUMN_NAME
|
Name of the column |
REFERENCED_SCHEMA
|
Referenced schema (only for foreign keys) |
REFERENCED_TABLE
|
Referenced table (only for foreign keys) |
REFERENCED_COLUMN
|
Name of the column in the referenced table (only for foreign keys) |
