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