Help Center/ GaussDB(DWS)/ Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ ALL_CONSTRAINTS
Updated on 2024-09-30 GMT+08:00
View PDF

ALL_CONSTRAINTS

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)
Parent topic: System Views