Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ System Catalogs and System Views/ System Views/ ADM_INDEXES
Updated on 2025-07-22 GMT+08:00
View PDF
Share

ADM_INDEXES

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

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

Specifies whether an index is unique.

partitioned

character(3)

Specifies whether the index has the property of partitioned tables.

generated

character varying(1)

Specifies whether the index name is generated by the system.
Parent topic: System Views