How to List All Tables in the Current MySQL Database?

Find out how to see all tables in the selected MySQL database

You can use the SHOW TABLES statement to list all tables in the currently selected MySQL database. For example:

SHOW TABLES;

It will produce an output like the following:

+-------------------+
| Tables_in_db_name |
+-------------------+
| user              |
| orders            |
+-------------------+

The name of the column in the output produced by the SHOW TABLES statement is always Tables_in_db_name, where db_name is the name of the database.


Hope you found this post useful. It was published . Please show your love and support by sharing this post.