Find All Tables in MySQL With Specific Column Names Example

Find All Tables in MySQL With Specific Column Names in specific schema. SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN (‘columnName1′,’columnName2′, columnNameN) AND TABLE_SCHEMA=’Database Name’; Find All Tables in MySQL With Specific Column Names in all schemas. SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN (‘columnName1′,’columnName2’, columnNameN)