SHOW TABLESedit

Warning

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

Synopsis. 

SHOW TABLES [ table identifier | [ LIKE pattern ] ]?

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.

SHOW TABLES;

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

Match multiple indices by using Elasticsearch multi index syntax notation:

SHOW TABLES "*,-l*";

     name      |     type
---------------+---------------
emp            |BASE TABLE
employees      |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
---------------+---------------
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