ALL_CONSTRAINTS

ALL_CONSTRAINTS describes constraint definitions on tables accessible to the current user.

Related Views

DBA_CONSTRAINTS describes all constraint definitions in the database.
USER_CONSTRAINTS describes constraint definitions on tables in the current user's schema.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the constraint definition
`CONSTRAINT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the constraint definition
`CONSTRAINT_TYPE`	`VARCHAR2(1)`		Type of constraint definition: `C` (check constraint on a table) `P` (primary key) `U` (unique key) `R` (referential integrity) `V` (with check option, on a view) `O` (with read only, on a view)
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name associated with the table (or view) with constraint definition
`SEARCH_CONDITION`	`LONG`		Text of search condition for a check constraint
`R_OWNER`	`VARCHAR2(30)`		Owner of table referred to in a referential constraint
`R_CONSTRAINT_NAME`	`VARCHAR2(30)`		Name of the unique constraint definition for referenced table
`DELETE_RULE`	`VARCHAR2(9)`		Delete rule for a referential constraint (`CASCADE` or `NO ACTION`)
`STATUS`	`VARCHAR2(8)`		Enforcement status of constraint (`ENABLED` or `DISABLED`)
`DEFERRABLE`	`VARCHAR2(14)`		Whether the constraint is deferrable
`DEFERRED`	`VARCHAR2(9)`		Whether the constraint was initially deferred
`VALIDATED`	`VARCHAR2(13)`		Whether all data obeys the constraint (`VALIDATED` or `NOT VALIDATED`)
`GENERATED`	`VARCHAR2(14)`		Whether the name of the constraint is user or system generated
`BAD`	`VARCHAR2(3)`		A `YES` value indicates that this constraint specifies a century in an ambiguous manner. To avoid errors resulting from this ambiguity, rewrite the constraint using the `TO_DATE` function with a four-digit year. See Also: the `TO_DATE` function in Oracle Database SQL Reference and Oracle Database Application Developer's Guide - Fundamentals
`RELY`	`VARCHAR2(4)`		Whether an enabled constraint is enforced or unenforced. See Also: the constraints in Oracle Database SQL Reference
`LAST_CHANGE`	`DATE`		When the constraint was last enabled or disabled
`INDEX_OWNER`	`VARCHAR2(30)`		Name of the user owning the index
`INDEX_NAME`	`VARCHAR2(30)`		Name of the index (only shown for unique and primary-key constraints)
`INVALID`	`VARCHAR2(7)`		Whether the constraint is invalid
`VIEW_RELATED`	`VARCHAR2(14)`		Whether the constraint depends on a view