Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ System Catalogs and System Views/ System Views/ DB_INDEXES
Updated on 2023-10-23 GMT+08:00
View PDF
Share

DB_INDEXES

DB_INDEXES displays information about indexes accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_INDEXES columns

Name

Type

Description

owner

character varying(64)

Index owner

index_name

character varying(64)

Index name

table_name

character varying(64)

Name of the table corresponding to the index

uniqueness

text

Whether the index is a unique index

partitioned

character(3)

Whether the index has the property of partitioned tables

generated

character varying(1)

Whether the index name is generated by the system
Parent topic: System Views