How to List User Defined Tables

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:




Read the rest of the post here:

Leave a Reply

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