Get a list of database tables that contain a specific column field?

How to select all tables that contain a specific column?

Answer

Is this what you expect?

demo: db<>fiddle

SELECT table_name
FROM information_schema.columns
WHERE column_name = 'your_column_name'