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