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


Learn more about the similar topics:
Tutorials
No Content Found.
Exercises & Assignments
No Content Found.
Interview Questions & Answers
No Content Found.