Help Center/ GaussDB/ Centralized_2.x/ System Catalogs and System Views/ System Views/ DB_INDEXES
Updated on 2023-10-23 GMT+08:00
View PDF

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 a table corresponding to an index

uniqueness

text

Whether an index is unique

partitioned

character(3)

Whether an index has the property of partitioned tables

generated

character varying(1)

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