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