USER_INDEXES displays index information in the current schema.
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 |