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.