You can execute the SHOW TABLES statement to list the names of tables in the current database.
Syntax
SHOW TABLES;
Examples
List the names of tables in the current database.
SHOW TABLES;
The following result is returned:
Tables_in_tpch
exampletable1
exampletable2