Find number of tables in MySQL database

The query below returns the total number of tables per database (schema).


select table_schema as 'database',
    count(*) as 'tables'
from information_schema.tables
where table_type = 'BASE TABLE'
group by table_schema;


  • database - name of the database (schema)
  • tables - number of tables in the database (schema)


  • One row: represents a database (schema)
  • Scope of rows: all databases (schemas)

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.