SQL Statements
SHOW TABLES statement
Overview
Show
statements allow you to obtain information about existing tables.
Example
Execute the following query to list all available tables:
SHOW TABLES;
This might produce an output with a list of all existing tables as shown below:
+------------+
| name |
+------------+
| lineorder |
| part |
| customer |
| supplier |
+------------+