EXA_ALL_CONSTRAINT_​COLUMNS

This system table contains information about referenced table columns of all constraints to which the current user has access. All users 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)