DBA_CONSTRAINTS

Columns

`OWNER`
`CONSTRAINT_NAME`
`CONSTRAINT_TYPE`	`P`: primary key, `R`: foreign key, `U`: unique key, `C`: check constraint, `V`: `with check option` (on views), `O`: `with read only` (on views), `H`: hash expression, `F`: ref expression constraint, `S`: supplemental logging
`TABLE_NAME`
`SEARCH_CONDITION`, `SEARCH_CONDITION_VC`	The condition of a check constraint as `long` and `varchar2(4000)`.
`R_OWNER`, `R_CONSTRAINT_NAME`	For foreign keys: identification of the primary or unique key constraint that the foreign key references
`DELETE_RULE`
`STATUS`	`ENABLED` or `DISABLED`
`DEFERRABLE`	`DEFERRABLE` or `NOT DEFERRABLE`
`DEFERRED`	`DEFERRED` or `IMMEDIATE`
`VALIDATED`	`VALIDATED` or `NOT VALIDATED`. Meaning depends on value of `STATUS`.
`GENERATED`	The value is either `USER NAME` or `GENERATED NAME` and indicates whether the name of the constraints was provided when the constraint was created: If the value is `GENERATED NAME`, the constraint name was chosen by Oracle and starts with `SYS_`.
`BAD`	`BAD` or `null`
`RELY`
`LAST_CHANGE`
`INDEX_OWNER`, `INDEX_NAME`	Identification of used index.
`INVALID`
`VIEW_RELATED`	`DEPEND ON VIEW` or `null`
`ORIGIN_CON_ID`