USER_INDEXES¶
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 |