To list all tables in the currently selected database, type the following command:
mysql> show tables;
Examples
The following example shows the basic use of this command:
mysql> show tables;
+-------------------+
| Tables_in_payroll |
+-------------------+
| employees |
+-------------------+
1 row in set (0.02 sec)
mysql>