Find columns across database in SQL Server

Best way to find a column referenced in different tables in database using SQL Server

select t.name from sys.columns c

inner join sys.tables t

on c.object_id = t.object_id

where c.name = '<Column Name>'