How to List All Tables in the Current MySQL Database?

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


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.