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)`		Owner of the constraint definition
`CONSTRAINT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the constraint definition
`CONSTRAINT_TYPE`	`VARCHAR2(1)`		Type of the 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 `H` - Hash expression `F` - Constraint that involves a REF column `S` - Supplemental logging
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name associated with the table (or view) with the constraint definition
`SEARCH_CONDITION`	`LONG`		Text of search condition for a check constraint
`R_OWNER`	`VARCHAR2(30)`		Owner of the table referred to in a referential constraint
`R_CONSTRAINT_NAME`	`VARCHAR2(30)`		Name of the unique constraint definition for the referenced table
`DELETE_RULE`	`VARCHAR2(9)`		Delete rule for a referential constraint: `CASCADE` `SET NULL` `NO ACTION`
`STATUS`	`VARCHAR2(8)`		Enforcement status of the constraint: `ENABLED` `DISABLED`
`DEFERRABLE`	`VARCHAR2(14)`		Indicates whether the constraint is deferrable (`DEFERRABLE`) or not (`NOT DEFERRABLE`)
`DEFERRED`	`VARCHAR2(9)`		Indicates whether the constraint was initially deferred (`DEFERRED`) or not (`IMMEDIATE`)
`VALIDATED`	`VARCHAR2(13)`		Indicates whether all data obeys the constraint (`VALIDATED`) or not (`NOT VALIDATED`)
`GENERATED`	`VARCHAR2(14)`		Indicates whether the name of the constraint is user-generated (`USER NAME`) or system-generated (`GENERATED NAME`)
`BAD`	`VARCHAR2(3)`		Indicates whether this constraint specifies a century in an ambiguous manner (`BAD`) or not (NULL). 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 Language Reference and Oracle Database Advanced Application Developer's Guide
`RELY`	`VARCHAR2(4)`		Indicates whether an enabled constraint is enforced (`RELY`) or unenforced (NULL) See Also: the constraints in Oracle Database SQL Language 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)`		Indicates whether the constraint is invalid (`INVALID`) or not (NULL)
`VIEW_RELATED`	`VARCHAR2(14)`		Indicates whether the constraint depends on a view (`DEPEND ON VIEW`) or not (NULL)