How to Find all tables that Contain a Specific Column in SQL Server

By f10debug | November 30, 2018

select * from INFORMATION_SCHEMA.COLUMNS 
where COLUMN_NAME like '%ProductName%' 
order by TABLE_NAME