Find all tables containing column with specified name

By | November 30, 2018

Here is how to find all tables containing column with specified name in sql server

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