FIND INDEX

Core command FIND INDEXES FI IX FIIX

Finds indexes whose name, table or columns contain the input text

Arguments

<text> (mandatory) part of an index, table or column name

Examples

FIND INDEX ORDERS;

Notes

Finds indexes by index name, table or column: FIND INDEX <text>.

Lists every index of the current schema whose name, table or one of whose columns contains the text. Matching ignores case, and, as with FIND COLUMN, % matches any sequence of characters and _ any single character. One row per indexed column, with its position (#) and UNIQUE or NON-UNIQUE; every column of a matching composite index is listed, even when only one of them matched. Table statistics are never shown as indexes.

Uses the same metadata as SHOW INDEXES, read for each table of the current schema, so a large schema takes a moment. Fails with an error if no text is given or if the JDBC driver cannot provide index metadata.

Last modified in release 5.3.1.