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:

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/

Leave a Reply

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