Help Center/ Data Warehouse Service/ More Documents/ Developer Guide (ME-Abu Dhabi Region)/ DWS System Catalogs and Views/ System Views/ USER_INDEXES
Updated on 2025-10-11 GMT+08:00
View PDF
Share

USER_INDEXES

USER_INDEXES displays index information in the current schema.

Column

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 unique

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