If you want to find a list of tables column contains the specific name in SQL server, you can easily using the following query. This query will be handy especially if you need to dig or trace where exactly the column come from.
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%ColumnName%' ORDER by TABLE_NAME