INDEX_
This Information Schema view displays a row for each column in the indexes 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. |
| INDEX_NAME | TEXT | Name of the index on the hybrid table. |
| NAME | TEXT | Name of the column that is participating in the index. |
| KEY_SEQUENCE | NUMBER | Position of the column in the index, starting from 1. |
| INDEX_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. |
| IS_INCLUDED_COLUMN | TEXT | With YES or NO, indicates whether this column is covered by an index. |