How to search a value in all tables in a database in sql server

Created Mar 8, 2016 Edited Mar 8, 2016

Viewed 7630

I want to get all the tables and column name having 'Hedge' as a column value. How can I find them?

sql-server sql