The USER_CONSTRAINTS view provides information about table constraints owned by the current user.
| Column name | Data type | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
The owner of the constraint definition. |
CONSTRAINT_NAME |
VARCHAR2(128) |
The name of the constraint definition. |
CONSTRAINT_TYPE |
VARCHAR2(1) |
The type of the constraint definition. |
TABLE_NAME |
VARCHAR(128) |
The name of the table with a constraint definition. |
SEARCH_CONDITION |
LONG |
The text of the search condition for a table check. |
R_OWNER |
VARCHAR2(128) |
The owner of the table used in a referential constraint. |
R_CONSTRAINT_NAME |
VARCHAR2(128) |
The name of the unique constraint definition for the referenced table. |
DELETE_RULE |
VARCHAR2(9) |
A delete rule for a referential constraint. The possible values are:
|
STATUS |
VARCHAR2(8) |
The status of the constraint. The possible values are:
|
DEFERRABLE |
VARCHAR2(14) |
Specifies whether the constraint is deferrable (DEFERRABLE) or not (NOT DEFERRABLE). |
DEFERRED |
VARCHAR2(9) |
Specifies whether the constraint was initially deferred (DEFERRED) or not (IMMEDIATE). |
VALIDATED |
VARCHAR2(13) |
Specifies whether all data obeys the constraint (VALIDATED) or not (NOT VALIDATED). |
GENERATED |
VARCHAR2(14) |
Specifies whether the name of the constraint is user-generated (USER NAME) or system-generated (GENERATED NAME). |
BAD |
VARCHAR2(3) |
Specifies whether the constraint specifies a century in an ambiguous manner (BAD) or not (NULL). |
RELY |
VARCHAR2(4) |
Specifies whether an enabled constraint is enforced (RELY) or unenforced (NULL). |
LAST_CHANGE |
DATE |
The date when the constraint was last enabled or disabled. |
INDEX_OWNER |
VARCHAR2(128) |
The name of the user owning the index. |
INDEX_NAME |
VARCHAR2(128) |
The name of the index, only shown for unique and primary key constraints. |