
Updated 11 May 2023
Did this page help you?
Yes
No
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 | +------------+