Find databases containing a particular table in MySQL

The query below finds all databases (schemas) in MySQL Server instance containing a particular table.


select table_schema as database_name
from information_schema.tables 
where table_type = 'BASE TABLE'
    and table_name = 'your table name'
order by table_schema;


  • database_name - name of the database (schema)


  • One row: represents one database (schema)
  • Scope of rows: all databases (schemas) containing the provided table name
  • Ordered by: database (schema) name

Sample results

The screen below shows all databases (schemas) that contain the country table.

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.