Relationships - Do you avoid using Cascade Delete?

Updated by Brady Stroud [SSW] 1 year ago. See history

123

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.

acknowledgements
related rules