Docs
IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
Elasticsearch Guide [6.3] » SQL Access » SQL Commands » SHOW TABLES
« SHOW FUNCTIONS Functions and Operators »

SHOW TABLESedit

Synopsis.

SHOW TABLES [ LIKE? pattern? ]?

SQL match pattern

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

SHOW TABLES;

     name      |     type
---------------+---------------
emp            |BASE TABLE
employees      |ALIAS
library        |BASE TABLE

The LIKE clause can be used to restrict the list of names to the given pattern.

The pattern can be an exact match:

SHOW TABLES LIKE 'emp';

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

Multiple chars:

SHOW TABLES LIKE 'emp%';

     name      |     type
---------------+---------------
emp            |BASE TABLE
employees      |ALIAS

A single char:

SHOW TABLES LIKE 'em_';

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

Or a mixture of single and multiple chars:

SHOW TABLES LIKE '%em_';

     name      |     type
---------------+---------------
emp            |BASE TABLE
« SHOW FUNCTIONS Functions and Operators »