SYS_TABLE_CONSTRAINTS contains information about table constraints, including the constraint type and the table to which the constraint applies.
| Column name | Data type | Description |
|---|---|---|
CONSTRAINT_CATALOG |
VARCHAR(128) |
A top-level container for constraints. Not used. Always NULL. |
CONSTRAINT_SCHEMA |
VARCHAR(128) |
A second-level container for constraints. Not used. Always NULL. |
CONSTRAINT_NAME |
VARCHAR(128) |
The name of the constraint. |
TABLE_CATALOG |
VARCHAR(128) |
A top-level container for tables. Not used. Always NULL. |
TABLE_SCHEMA |
VARCHAR(128) |
A second-level container for tables. Not used. Always NULL. |
TABLE_NAME |
VARCHAR(128) |
The name of the object to which the constraint belongs. |
CONSTRAINT_TYPE |
VARCHAR(11) |
The type of the constraint. The possible values are:
|
IS_DEFERRABLE |
VARCHAR(3) |
Not used. Always NO. |
INITIALLY_DEFERRED |
VARCHAR(3) |
Not used. Always NO. |