The following is a sample script of how to find a column name within all the tables in your database.

SELECT table.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, column.name AS column_name
FROM sys.tables AS table
INNER JOIN sys.columns column ON table.OBJECT_ID = column.OBJECT_ID
WHERE column.name LIKE '%ColumnNameId%'
ORDER BY schema_name, table_name;