Retrieve the number of tables in a mysql database

To find out the number of tables in a particular mysql database, you can use the following sql statement.

SELECT count(*) from information_schema.tables WHERE table_schema = 'dbname';