Synopsis.
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 |VIEW library |BASE TABLE
Match multiple indices by using Elasticsearch multi index syntax notation:
SHOW TABLES "*,-l*"; name | type ---------------+--------------- emp |BASE TABLE employees |VIEW
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 |VIEW
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