How to List All tables in a MySQL database

by Ismail.EL
0 comment

To see all the tables in the database you can use the following statement :   

show tables;

To list/show the tables in a MySQL database:

  1. Log into your database using the MySQL client,
  2. Issue the use command to connect to your desired database, and then
  3. Use the MySQL show tables command, like this: “show tables;”

MySQL show tables – A complete example :

First, connect to your MySQL database using your MySQL client from your operating system command line:

Next, after you’re logged into your MySQL database, tell MySQL which database you want to use:

And now issue the MySQL show tables command to list the tables in the current database:


IIn this post, i have explained How to List All tables in a MySQL database.
If you have any questions or feedback, feel free to leave a comment.
As always, if you found this post useful, then click like and share it 🙂

19430cookie-checkHow to List All tables in a MySQL database

Related Posts

Leave a Comment