EXA_USER_CONSTRAINT​_COLUMNS

This system table contains information about referenced table columns of all constraints owned by the current user. 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 constraints
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)