Find databases (schemas) containing a particular table on MariaDB server

The query below finds all databases (schemas) 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 - database (schema) name


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

Sample results

The screen below shows all the databases (schemas) that contain the customer 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.