List all tables in a mysql database

In this programming tutorial we will learn how to list all tables in a mysql database. Sometimes you may want to get the table names of a mysql database; in that case the below mentioned show command will be very handy to you. It is as simple as reading a,b,c. Let’s have a look over it.

Show or List all tables in a mysql database
First of all you have to select the database whose tables you want to see.
Using this command, you will select the database.

use your_db_name

Replace your_db_name with the database name. And then use below mentioned command to get list of all tables in that database.

show tables

Yeah show tables command will do what you want.

So that’s it.
I love your feedback