Find all tables containing column with specified name - MS SQL Server

Is it possible to query for table names which contain columns being

LIKE '%myName%'

?