Definition: The show tables SQL command is used to display all of the tables in a MySQL database and is phrased as: show tables;
Examples:
This would list all of the tables in your database:
show tables;
By Angela Bradley, About.com Guide
show tables;