Mysql number of tables in DB

SELECT COUNT(*) FROM information_schema.TABLES WHERE table_schema = 'databasename';

Leave a Reply