EXA_DBA_CONSTRAINTS

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