Get all Tables from Selected Database

What is the query to get all tables from the selected database in MYSQL?

Questions by joerun

Showing Answers 1 - 3 of 3 Answers


  • Mar 8th, 2010

Assuming you are at the mysql> prompt ...

mysql> use [databasename]; -- to switch to the database you want to use
mysql> show tables; -- get all tables from selected database

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions