MySQL query to search a table name from multiple databases

MySQL query to search a table name from multiple databases

If we are using multiple database,We will face problem on searching a particular table_name in phpmyadmin. While using this below query, we can find out easily either table is present or not in multiple tables.

Explanation:

INFORMATION_SCHEMA provides access to database metadata.Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.