Find all occurrances of a field-column

SELECT         c.name  AS 'ColumnName'   ,(SCHEMA_NAME(t.schema_id) + '.' + t.name) AS 'TableName' FROM           sys.columns c   JOIN