This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.
SHOW TABLES
editSHOW TABLES
editSynopsis:
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. |
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