How to write a query to find all tables in a db that have a specific column name
Using information_schema

This is the standards-compliant cross-RDBMS way to do it.

SELECT table_catalog, table_schema, table_name, column_name
FROM INFORMATION_SCHEMA.columns
WHERE column_name = '&lt;your column name&gt;';


You can see this documented


PostgreSQL
SQL Server
MySQL 8.0