Find all tables containing column with specified name
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
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