select * from sys.sql_expression_dependencies d
inner join sys.views v on d.referencing_id=v.object_id
inner join sys.tables t on d.referenced_id=t.object_id
inner join sys.check_constraints c on t.object_id=c.parent_object_id
inner join sys.sql_modules m on v.object_id=m.object_id
where m.definition like '%UNION ALL%'