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.