MySQL SHOW TABLES shows Views also

I had a problem with getting the list of the tables in a mysql db.

MySQL 5.0 offers Views so the usual

SHOW TABLES

is not accurate

Used this to get the tables alone

SHOW FULL TABLES WHERE Table_type = ‘BASE TABLE’Â

Published by

Varun Krish

Varun Krish has been dabbling with computers and websites for almost 2 decades. He has traveled to over 30 countries and hopes to visit every country on earth one day. He is currently the Editor-in-Chief of FoneArena.com and also advises startups and product companies on how to build better products. You can follow him on @varunkrish

Leave a Reply

Your email address will not be published.