The USER_CONSTRAINTS view provides the information about all constraints placed on tables that are owned by the current user.

Parameter Type Description
owner TEXT The name of the owner of the constraint.
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.