Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (8.1.3.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ DBA_INDEXES
Updated on 2023-04-14 GMT+08:00
View PDF
Share

DBA_INDEXES

DBA_INDEXES displays all indexes in the database. This view is accessible only to users with system administrator rights.

Name

Type

Description

owner

character varying(64)

Owner of the index

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

generated

character varying(1)

Whether the index name is generated by the system

partitioned

character(3)

Whether the index has the property of the partition table
Parent topic: System Views