The query below finds all databases (schemas) containing a particular table.

Query

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;

Columns

• database_name - database (schema) name

Rows

• 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.