The objects that help you find this info in SQL Server are in sys.tables and sys.columns

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

This will bring back every table that has a reference to '%YourColumnNameHere%'