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) |