SHOW TABLES

Synopsis:

  1. SHOW TABLES
  2.     [INCLUDE FROZEN]?   
  3.     [table identifier | 
  4.     [LIKE pattern ]]?

Whether or not to include frozen indices

single table identifier or double quoted es multi index

SQL LIKE pattern

See index patterns for more information about patterns.

Description: List the tables available to the current user and their type.

  1. SHOW TABLES;
  3.      name      | type     |     kind
  4. ---------------+----------+---------------
  5. emp            |TABLE     |INDEX
  6. employees      |VIEW      |ALIAS
  7. library        |TABLE     |INDEX

Match multiple indices by using Elasticsearch multi-target syntax notation:

  1. SHOW TABLES "*,-l*";
  3.      name      | type     |     kind
  4. ---------------+----------+---------------
  5. emp            |TABLE     |INDEX
  6. employees      |VIEW      |ALIAS

One can also use the LIKE clause to restrict the list of names to the given pattern.

The pattern can be an exact match:

  1. SHOW TABLES LIKE 'emp';
  3.      name      | type     |     kind
  4. ---------------+----------+---------------
  5. emp            |TABLE     |INDEX

Multiple chars:

  1. SHOW TABLES LIKE 'emp%';
  3.      name      | type     |     kind
  4. ---------------+----------+---------------
  5. emp            |TABLE     |INDEX
  6. employees      |VIEW      |ALIAS

A single char:

  1. SHOW TABLES LIKE 'em_';
  3.      name      | type     |     kind
  4. ---------------+----------+---------------
  5. emp            |TABLE     |INDEX

Or a mixture of single and multiple chars:

  1. SHOW TABLES LIKE '%em_';
  3.      name      | type     |     kind
  4. ---------------+----------+---------------
  5. emp            |TABLE     |INDEX