EXA_ALL_CONSTRAINTS

This system table contains information about constraints of tables 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_ENABLED Displays whether the constraint is checked or not
CONSTRAINT_OWNER Owner of the constraint (which is the owner of the table)