Get all table names with a given column name

Select table_name from information_Schema.columns where
column_name='column name'