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