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.
WHERE `TABLE_NAME` = 'your_table_name'
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.