SHOW-INDEX

Name

SHOW INDEX

Description

This statement is used to display information about indexes in a table.

grammar:

  1. SHOW INDEX[ES] FROM [db_name.]table_name [FROM database];
  2. or
  3. SHOW KEY[S] FROM [db_name.]table_name [FROM database];

Example

  1. Display the lower index of the specified table_name

    1. SHOW INDEX FROM example_db.table_name;

Keywords

  1. SHOW, INDEX

Best Practice