Show All tables in MySQL

If you want to see all the tables in existing MySQL database then we can make use of show tables command of MySQL.

MySQL show tables statement will return all the tables exists in MySQL database;

SHOW Tables;

As discussed show tables statement will display all the tables in database.

before using show tables, you have to execute use database command, otherwise you can get ERROR 1046 (3D000): No database selected error.