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.
Replace your_db_name with the database name. And then use below mentioned command to get list of all tables in that database.
Yeah show tables command will do what you want.
So that’s it.
I love your feedback