ALL_INDEXES¶
ALL_INDEXES displays information about indexes accessible to the current user.
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 |