Find specific column names from all tables.

Find specific column names from all tables.

SELECT DISTINCT TABLE_NAME 

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE COLUMN_NAME IN ('columnA','ColumnB')

        AND TABLE_SCHEMA='YourDatabase';

ex.

SELECT *

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE COLUMN_NAME like '%code%'

        AND TABLE_SCHEMA='world';