There are two different methods to list out user-defined tables in MySQL. The first method is to use SHOW TABLES command. Sow tables will list all the user-defined tables in the database.
The command is: SHOW TABLES;
You can also use database name along with this command like:
SHOW TABLES FROM <database name>
Where <database name> is the name of your database.
This will yield you with the same results.
The second method is to use INFORMATION_SCHEMA view.
With this method, you can make use of ANSI standard INFORMATION_SCHEMA..TABLES to view your user-defined tables. Do it like this:
SELECT TABLE_NAME FROM
INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = ‘Test’;
Read the rest of the post here:Â http://blog.sqlauthority.com/2014/04/01/mysql-list-user-defined-tables-two-methods/