我可以在SQL Server中删除之前检查约束吗？

I have following situation. A main table and many other tables linked together with foreign keys. Now when I would like to delete a row in the main table a ConstraintsViolation will occur, which is intended and good.I have following situation. A main table and ma