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