MySQL Top Queries

MySQL Top Queries – Code, Program & Snippets Collection – Free Code Script for Students project & practise | Tutorials Class

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
   WHERE TABLE_SCHEMA = 'mydatabase';

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