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

Parameter Type Description
owner TEXT The username of the owner to which the constraint belongs.
schema_name TEXT The name of the schema to which the constraint belongs.
constraint_name TEXT The name of the constraint.
constraint_type TEXT The type of the constraint. Valid values:
  • C: the check constraint
  • F: the foreign key constraint
  • P: the primary key constraint
  • U: the unique key constraint
  • R: the referential integrity constraint
  • V: the constraint on a view
  • O: with a read-only property on a view
table_name TEXT The name of the table to which the constraint belongs.
search_condition TEXT The search condition that applies to a check constraint.
r_owner TEXT The owner of a table referenced by a referential constraint.
r_constraint_name TEXT The name of the constraint definition for a referenced table.
delete_rule TEXT The delete rule for a referential constraint. Valid values:
  • C: cascade
  • R: restrict
  • N: no action
deferrable BOOLEAN Indicates if the constraint is deferrable. Valid values: T and F.
deferred BOOLEAN Indicates if the constraint has been deferred. Valid values: T and F.
index_owner TEXT The username of the owner to which the index belongs.
index_name TEXT The name of the index.
constraint_def TEXT The definition of the constraint.