SQL Server finding all tables containing a particular column in the database

Below the the query SQL Server finding all tables containing a particular column in the database

SELECT
  sys.columns.name AS ColumnName,
  tables.name AS TableName
FROM
  sys.columns
JOIN sys.tables ON
  sys.columns.object_id = tables.object_id
WHERE
  sys.columns.name like '%ColumnName%'