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 - 0 of 0 Answers

Tejanshu

  • 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