SELECT OBJECT_SCHEMA_NAME(dep.referencing_id) AS [schema] ,referencing_entity.name ,CASE referencing_entity.type WHEN 'V' THEN N'VIEW' ELSE /*IF, FN, TF*/ N'FUNCTION' END as [type] FROM sys.sql_expression_dependencies AS dep INNER JOIN sys.objects AS referencing_entity ON dep.referencing_id = referencing_entity.object_id WHERE dep.referenced_entity_name = @EntityName AND dep.referenced_schema_name = @SchemaName AND is_schema_bound_reference = 1 AND ((@ColumnName IS NULL AND dep.referenced_minor_id = 0) OR COL_NAME(dep.referenced_id, dep.referenced_minor_id) = @ColumnName)