INDEXES view¶
This Information Schema view displays a row for each index defined in the specified (or current) database.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| TABLE_CATALOG | TEXT | Database to which the hybrid table belongs. |
| TABLE_SCHEMA | TEXT | Schema to which the hybrid table belongs. |
| TABLE_NAME | TEXT | Name of the hybrid table where the index is defined. |
| NAME | TEXT | Name of the index on the hybrid table. |
| OWNER | TEXT | Owner of the index. |
| IS_UNIQUE | TEXT | With YES or NO, indicates whether this index is a unique index. |
| CONSTRAINT_NAME | TEXT | Name of the constraint that is associated with this index. |
| STATUS | TEXT | Status of this index. |
| CREATED | TIMESTAMP_LTZ | Time of creation for this index. |