How to Find all tables that Contain a Specific Column in SQL Server
select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%ProductName%' order by TABLE_NAME
How to Find all tables that Contain a Specific Column in SQL Server
select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%ProductName%' order by TABLE_NAME