Relationships - Do you know to not use ON DELETE CASCADE clause when creating relationship?
  v1.0 Posted at 13/11/2019 11:58 AM by Tiago Araujo
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.​

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address: