Help Center > > Developer Guide> System Catalogs and System Views> System Views> ALL_CONSTRAINTS

ALL_CONSTRAINTS

Updated at: Jul 15, 2020 GMT+08:00

ALL_CONSTRAINTS displays information about constraints accessible to the current user.

Table 1 ALL_CONSTRAINTS columns

Name

Type

Description

constraint_name

vcharacter varying(64)

Constraint name

constraint_type

text

Constraint type

  • C: Check constraint.
  • F: Foreign key constraint
  • P: Primary key constraint
  • U: Unique constraint.

table_name

character varying(64)

Name of constraint-related table

index_owner

character varying(64)

Owner of constraint-related index (only for the unique constraint and primary key constraint)

index_name

character varying(64)

Name of constraint-related index (only for the unique constraint and primary key constraint)

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel