How can I find all the tables in MySQL with specific column names in them?

by

I have 2-3 different column names that I want to look up in the entire database and list out all tables which have those columns. Is there any easy script?

1Best Answer
11

To get all tables with columns columnA or ColumnB in the database YourDatabase:

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Leave a Comment