To find the schema that conatins the given table name

1. select table_name, table_schema from information_schema.Tables order by table_name;