ALL_CONSTRAINTS v17

The ALL_CONSTRAINTS view provides information about the constraints placed on tables accessible by the current user.

NameTypeDescription
ownerTEXTUser name of the constraint’s owner.
schema_nameTEXTName of the schema in which the constraint belongs.
constraint_nameTEXTName of the constraint.
constraint_typeTEXTThe constraint type. Possible values are: C – check constraint; F – foreign key constraint; P – primary key constraint; U – unique key constraint; R – referential integrity constraint; V – constraint on a view; O – with read-only, on a view
table_nameTEXTName of the table to which the constraint belongs.
search_conditionTEXTSearch condition that applies to a check constraint.
r_ownerTEXTOwner of a table referenced by a referential constraint.
r_constraint_nameTEXTName of the constraint definition for a referenced table.
delete_ruleTEXTDelete rule for a referential constraint. Possible values are: C – cascade; R – restrict; N – no action
deferrableBOOLEANSpecified if the constraint is deferrable (T or F).
deferredBOOLEANSpecified if the constraint was deferred (T or F).
index_ownerTEXTUser name of the index owner.
index_nameTEXTName of the index.
constraint_defTEXTDefinition of the constraint.