Mute Duck

Finds table names that contain a given column name.

SELECT
      tables.name       AS [Table_Name]
    , sys.columns.name  AS [Column_Name]
FROM
    sys.columns
JOIN sys.tables ON
    sys.columns.object_id = tables.object_id

WHERE
    sys.columns.name = 'ColumnName'

ORDER BY
    tables.name