IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
Elastic Docs ›Elasticsearch Guide [7.5] ›SQL access ›SQL Language
« SHOW FUNCTIONS Data Types »

SHOW TABLESedit

Synopsis.

SHOW TABLES
    [INCLUDE FROZEN]?   
    [table identifier | 
    [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.

DescriptionList the tables available to the current user and their type.

SHOW TABLES;

     name      |     type      |     kind
---------------+---------------+---------------
emp            |BASE TABLE     |INDEX
employees      |VIEW           |ALIAS
library        |BASE TABLE     |INDEX

Match multiple indices by using Elasticsearch multi index syntax notation:

SHOW TABLES "*,-l*";

     name      |     type      |     kind
---------------+---------------+---------------
emp            |BASE TABLE     |INDEX
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:

SHOW TABLES LIKE 'emp';

     name      |     type      |     kind
---------------+---------------+---------------
emp            |BASE TABLE     |INDEX

Multiple chars:

SHOW TABLES LIKE 'emp%';

     name      |     type      |     kind
---------------+---------------+---------------
emp            |BASE TABLE     |INDEX
employees      |VIEW           |ALIAS

A single char:

SHOW TABLES LIKE 'em_';

     name      |     type      |     kind
---------------+---------------+---------------
emp            |BASE TABLE     |INDEX

Or a mixture of single and multiple chars:

SHOW TABLES LIKE '%em_';

     name      |     type      |     kind
---------------+---------------+---------------
emp            |BASE TABLE     |INDEX
« SHOW FUNCTIONS Data Types »