​
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   | 
+------------+