OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the constraint definition |
CONSTRAINT_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the constraint definition |
CONSTRAINT_TYPE |
VARCHAR2(1) |
|
Type of constraint definition:
-
C (check constraint on a table)
-
P (primary key)
-
U (unique key)
-
R (referential integrity)
-
V (with check option, on a view)
-
O (with read only, on a view)
|
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name associated with the table (or view) with constraint definition |
SEARCH_CONDITION |
LONG |
|
Text of search condition for a check constraint |
R_OWNER |
VARCHAR2(30) |
|
Owner of table referred to in a referential constraint |
R_CONSTRAINT_NAME |
VARCHAR2(30) |
|
Name of the unique constraint definition for referenced table |
DELETE_RULE |
VARCHAR2(9) |
|
Delete rule for a referential constraint (CASCADE or NO ACTION) |
STATUS |
VARCHAR2(8) |
|
Enforcement status of constraint (ENABLED or DISABLED) |
DEFERRABLE |
VARCHAR2(14) |
|
Whether the constraint is deferrable |
DEFERRED |
VARCHAR2(9) |
|
Whether the constraint was initially deferred |
VALIDATED |
VARCHAR2(13) |
|
Whether all data obeys the constraint (VALIDATED or NOT VALIDATED) |
GENERATED |
VARCHAR2(14) |
|
Whether the name of the constraint is user or system generated |
BAD |
VARCHAR2(3) |
|
A YES value indicates that this constraint specifies a century in an ambiguous manner. To avoid errors resulting from this ambiguity, rewrite the constraint using the TO_DATE function with a four-digit year.
See Also: the TO_DATE function in Oracle Database SQL Reference and Oracle Database Application Developer's Guide - Fundamentals |
RELY |
VARCHAR2(4) |
|
Whether an enabled constraint is enforced or unenforced.
See Also: the constraints in Oracle Database SQL Reference |
LAST_CHANGE |
DATE |
|
When the constraint was last enabled or disabled |
INDEX_OWNER |
VARCHAR2(30) |
|
Name of the user owning the index |
INDEX_NAME |
VARCHAR2(30) |
|
Name of the index |
INVALID |
VARCHAR2(7) |
|
Whether the constraint is invalid |
VIEW_ONLY |
VARCHAR2(14) |
|
Whether the constraint depends on a view |
