Updated on 2025-07-15 GMT+08:00

ADM_INDEXES

ADM_INDEXES displays all indexes in the database. By default, only users with the SYSADMIN permission can access this view. Common users can access the view 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 the index is a unique index.

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.