VarunKrish

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’Â

Exit mobile version