Welcome to the Lounge

USE MyDatabase

DECLARE @SchemaName nvarchar(128) = 'dbo'
DECLARE @TableName  nvarchar(128) = 'TableWithColumnToRemove'
DECLARE @ColumnName nvarchar(128) = 'ColumnToRemove'
;

SELECT  SCHEMA_NAME(o1.schema_id) + '.' + o1.name ReferencingObject
       ,SCHEMA_NAME(o2.schema_id) + '.' + ed.referenced_entity_name ReferencedObject
       ,c.name ColumnName
       ,o2.type ReferencedObjectType
       ,o1.type ReferencingObjectType
FROM    sys.sql_expression_dependencies ed
JOIN    sys.objects o1 ON ed.referencing_id = o1.object_id
JOIN    sys.objects o2 ON ed.referenced_id = o2.object_id
JOIN    sys.sql_dependencies d ON ed.referencing_id = d.object_id
    AND d.referenced_major_id = ed.referenced_id
JOIN    sys.columns c ON c.object_id = ed.referenced_id
    AND d.referenced_minor_id = c.column_id
WHERE   1=1
    AND SCHEMA_NAME(o2.schema_id) = @SchemaName
    AND o2.name = @TableName
    AND c.name = @ColumnName
ORDER BY ReferencedObject
    ,c.column_id;