Loading
SHOW TABLES
SHOW TABLES [CATALOG [catalog_identifier | LIKE pattern]]? [INCLUDE FROZEN]? [table_identifier | LIKE pattern]?- Catalog (cluster) identifier. Supports wildcards (
*). - SQL LIKE pattern matching catalog names.
- Whether or not to include frozen indices.
- Single table (index or data stream) identifier or double-quoted multi-target pattern.
- SQL LIKE pattern matching table names.
Seeindex 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 |INDEXjavaRestTest |employees |VIEW |ALIASjavaRestTest |library |TABLE |INDEXMatch multiple indices by using Elasticsearchmulti-target syntax notation:
SHOW TABLES "*,-l*"; catalog | name | type | kind---------------+---------------+----------+---------------javaRestTest |emp |TABLE |INDEXjavaRestTest |employees |VIEW |ALIASOne can also use theLIKE 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 |INDEXMultiple chars:
SHOW TABLES LIKE 'emp%'; catalog | name | type | kind---------------+---------------+----------+---------------javaRestTest |emp |TABLE |INDEXjavaRestTest |employees |VIEW |ALIASA single char:
SHOW TABLES LIKE 'em_'; catalog | name | type | kind---------------+---------------+----------+---------------javaRestTest |emp |TABLE |INDEXOr a mixture of single and multiple chars:
SHOW TABLES LIKE '%em_'; catalog | name | type | kind---------------+---------------+----------+---------------javaRestTest |emp |TABLE |INDEXList 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 |INDEXmy_remote_cluster|test_emp_copy |TABLE |INDEX