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

ADM_INDEXES

ADM_INDEXES displays all indexes in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

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