Loading

SHOW TABLES

SHOW TABLES [CATALOG [catalog_identifier | LIKE pattern]]? [INCLUDE FROZEN]? [table_identifier | LIKE pattern]?
  1. Catalog (cluster) identifier. Supports wildcards (*).
  2. SQL LIKE pattern matching catalog names.
  3. Whether or not to include frozen indices.
  4. Single table (index or data stream) identifier or double-quoted multi-target pattern.
  5. SQL LIKE pattern matching table names.

See index patterns for more information about patterns.

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

SHOW TABLES; catalog | name | type | kind ---------------+---------------+----------+--------------- javaRestTest |emp |TABLE |INDEX javaRestTest |employees |VIEW |ALIAS javaRestTest |library |TABLE |INDEX

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

SHOW TABLES "*,-l*"; catalog | name | type | kind ---------------+---------------+----------+--------------- javaRestTest |emp |TABLE |INDEX javaRestTest |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'; catalog | name | type | kind ---------------+---------------+----------+--------------- javaRestTest |emp |TABLE |INDEX

Multiple chars:

SHOW TABLES LIKE 'emp%'; catalog | name | type | kind ---------------+---------------+----------+--------------- javaRestTest |emp |TABLE |INDEX javaRestTest |employees |VIEW |ALIAS

A single char:

SHOW TABLES LIKE 'em_'; catalog | name | type | kind ---------------+---------------+----------+--------------- javaRestTest |emp |TABLE |INDEX

Or a mixture of single and multiple chars:

SHOW TABLES LIKE '%em_'; catalog | name | type | kind ---------------+---------------+----------+--------------- javaRestTest |emp |TABLE |INDEX

List tables within remote clusters whose names are matched by a wildcard:

SHOW TABLES CATALOG 'my_*' LIKE 'test_emp%'; catalog | name | type | kind -----------------+---------------+---------------+--------------- my_remote_cluster|test_emp |TABLE |INDEX my_remote_cluster|test_emp_copy |TABLE |INDEX