Constraint definitions on all tables
Columns
___________________________
OWNER
Owner of the table
CONSTRAINT_NAME
Name associated with constraint definition
CONSTRAINT_TYPE
Type of constraint definition
TABLE_NAME
Name associated with table with constraint definition
SEARCH_CONDITION
Text of search condition for table check
R_OWNER
Owner of table used in referential constraint
R_CONSTRAINT_NAME
Name of unique constraint definition for referenced table
DELETE_RULE
The delete rule for a referential constraint
STATUS
Enforcement status of constraint - ENABLED or DISABLED
DEFERRABLE
Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE
DEFERRED
Is the constraint deferred by default - DEFERRED or IMMEDIATE
VALIDATED
Was this constraint system validated? - VALIDATED or NOT VALIDATED
GENERATED
Was the constraint name system generated? - GENERATED NAME or USER NAME
BAD
Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
RELY
If set,this flag will be used in optimizer
LAST_CHANGE
The date when this column was last enabled or disabled
INDEX_OWNER
The owner of the index used by this constraint
INDEX_NAME
The index used by this constraint
INVALID
--
VIEW_RELATED
--