Thursday, January 31, 2019

Searching Table Name, Schema name from Mysql Database

Search a Table name, Schema name where table is created in mysql:

SELECT table_schema DBase, table_name TableName FROM information_schema.tables WHERE table_name LIKE '%PARAMETERS%';