Just a simple trick to retrieve all tables in database that have columns with specified names.
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'COLUMN_NAME'
AND TABLE_SCHEMA = 'DATABASE_NAME';
You can group to search for more columns by providing a list of column names.
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('COLUMN_NAME_1', 'COLUMN_NAME_2')
AND TABLE_SCHEMA = 'DATABASE_NAME';
These are just examples to show that all columns’ information are stored in INFORMATION_SCHEMA.COLUMNS, you can query and filter to suit your requirements.
