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;
Show Tables SQL Command
By Angela Bradley, About.com
Related Commands
Show Databases with SQLShow Columns with SQLDrop Table with SQL
Join Us!
Explore PHP / MySQL
Must Reads
More from About.com
Work Hard, Travel Easy
The best tips for business travelers.Dog Care
Get tips on training and caring for dogs of all ages.48 Hours in Vegas
Plan a hot weekend in Sin City.Hotel Advice
The must-stay hotels worldwide.
©2008 About.com, a part of The New York Times Company.
All rights reserved.