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

By | November 30, 2018

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

 

Leave a Reply

Your email address will not be published. Required fields are marked *