SHOW INDEXES

This view has a single row for each index in the database. The output is ordered by the (table_name,index_name) columns. Data can be filtered with IN TABLE table_name syntax. Note, this view contains both indexes created explicitly by the user and indexes created implicitly for PRIMARY KEY and UNIQUE and REFERENCES constraints. The following table lists the output’s columns:

Column name	Data type	Description
TABLE_NAME	VARCHAR(127)	The table name
INDEX_NAME	VARCHAR(127)	The index name. This is the filter column.
IS_UNIQUE	BOOLEAN	True if the index is unique. False if not.
COLUMN_NAME	VARCHAR(127)	The index column name
DEVICES	VARCHAR(1000)	List of devices on which the index is stored, separated by comma. Note: The output is trimmed after 1000 chars. To see the full list of devices use SHOW INDEX DEVICES.
RANGE_SEPARATORS	VARCHAR	Separators of the key ranges of the segments, if any. The column output max size is limited by the Max SQL statement length.

SHOW TABLE DEVICES SHOW INDEX DEVICES

⌘I

SQL Specification

SQL Syntax Conventions

Data Types

SQL Functions and Operators

Data Definition Language (DDL) Commands

Data Manipulation Language Commands

Transaction Control Language Commands

Data Query Language

Hints

Managing Users

System Monitoring

System Management

Appendices