20. SHOW TABLES#
20.1. Synopsis#
SHOW TABLES [ LIMIT <max_count> ]
20.2. Description#
SHOW TABLES lists the tables that are available in the system.
This command requires the SELECT privilege.
Use LIMIT to set the maximum number of returned tables.
20.3. Examples#
List all the tables in the cluster:
SHOW TABLES
List a maximum of 100 tables:
SHOW TABLES LIMIT 100