INDEX_COLUMNS view¶

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