Count tables within a DB, nice and easy.. use db_name; select count(*) from information_schema.tables where table_schema = database();