Help Center/ GaussDB(DWS)/ More Documents/ Developer Guide (ME-Abu Dhabi Region)/ System Catalogs and System Views/ System Views/ USER_INDEXES
Updated on 2022-06-11 GMT+08:00
View PDF
Share

USER_INDEXES

USER_INDEXES displays index information in the current schema.

Table 1 USER_INDEXES columns

Name

Type

Description

owner

character varying(64)

Index owner

index_name

character varying(64)

Index name

table_name

character varying(64)

Table name for 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