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 hybrd table belongs. |
TABLE_NAME |
TEXT |
Name of the hybrid table that the index is over. |
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. |