Tejanshu

 Profile Answers by 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

Subhashini J

 Profile Answers by Subhashini J 

• Mar 8th, 2010

 

use databasename;
show tables;

umapathi.b

 Profile Answers by umapathi.b 

• Jul 24th, 2010

 

SELECT table_name FROM information_schema.tables WHERE table_schema = 'dbname';