ALL_CONSTRAINTS

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
      --

Related: