Relationships - Do you avoid using Cascade Delete?
31/12/2019 5:16 PM by
SQL Servers ON DELETE CASCADE functionality can be very dangerous. We recommend not using it. Imagine someone deletes customer and the orders are deleted. If you need to delete records in related tables, do it in code in the application as it gives you more control.
Do you feel this rule needs an update?