Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> ALL_INDEXES
View PDF

ALL_INDEXES

ALL_INDEXES displays information about indexes accessible to the current user.

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

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