Relationships - Do you know to not use ON DELETE CASCADE clause when creating relationship?
13/11/2019 11:58 AM 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?