SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' AND table_name like '%YOUR TABLE NAME%';
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('columnA','ColumnB') AND TABLE_SCHEMA='YourDatabase';