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‘

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.