EXA_DBA_CONSTRAINT​_COLUMNS
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) |