MySQL Top Queries

MySQL – Count the number of tables in the database

Here is the MySQL query code to count the number of tables in database.

SELECT count(*) AS Total_Tables
   FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_SCHEMA = 'mydatabase';

Note: You can add your database name instead of ‘mydatabase‘