Home / Database Structure / Question No: 133

I need to know about all existing tables in MySQL database. Is there any command in the MySQL that may help me to show all existing tables in my database?

You can get all existing tables by MySQL SHOW TABLES statement. Run this statement using any MySQL client like phpMyAdmin etc and get all existing tables. Take an example, this will show you all existing tables in the current database:

SHOW TABLES;

If you want to get existing tables of another database instead of current database, take the following example. This will show you all tables of named database.

SHOW TABLES FROM database_name;