Write a SELECT that includes the following text:

SHOW TABLES FROM <databaseName>;

This will present you with a list of the MySQL data dictionary type tables in your database, you can then also add a ‘WHERE’ or ‘LIKE’ command to the SQL above in order to filter the results.

How do I get a list of my MySQL tables?

Leave a Reply

Your email address will not be published. Required fields are marked *

fifty six + = sixty two