Updated 09 Oct 2023

Did this page help you?
Show statements allow you to obtain information about existing tables.
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 | +------------+