The DBA_CONSTRAINTS view provides the information about all constraints on tables in the database.

Parameter Type Description
owner TEXT The username of the owner to which a 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 whether the constraint is deferrable. Valid values: T and F.
deferred BOOLEAN Indicates whether the constraint has been deferred. Valid values: T and F.
index_owner TEXT The username of the owner to which an index belongs.
index_name TEXT The name of the index.
constraint_def TEXT The definition of the constraint.