​
Overview

The SHOW TABLES statement allows you to obtain information about existing tables.

It only shows tables in schemas, on which a user has the USAGE grant

​
Example

So as to list all available tables, you need to execute the following query:

SHOW TABLES;

This will produce an output with a list of all existing tables, an example of which is presented below:

+------------+
| name       |  
+------------+
| lineorder  |
| part       | 
| customer   | 
| supplier   | 
+------------+
DROPDESCRIBE