ALL_CONSTRAINTS

Constraint definitions on accessible tables
Columns
   ___________________________
 
   CONSTRAINT_TYPE
      Type of constraint definition
   CONSTRAINT_NAME
      Name associated with constraint definition
   VALIDATED
      Was this constraint system validated? -  VALIDATED or NOT VALIDATED
   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
   BAD
      Creating this constraint should give ORA-02436.  Rewrite it before 2000 AD.
   RELY
      If set, this flag will be used in optimizer
   OWNER
      Owner of the table
   LAST_CHANGE
      The date when this column was last enabled or disabled
   DEFERRED
      Is the constraint deferred by default -  DEFERRED or IMMEDIATE
   GENERATED
      Was the constraint name system generated? -  GENERATED NAME or USER NAME
Related Commands:
Simon Sheppard
SS64.com