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

DBA_CONSTRAINTS

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

DBA_CONSTRAINTS displays information about table constraints in database. It is accessible only to users with system administrator rights.

Table 1 DBA_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