Relationships - Do you avoid using Cascade Delete?
Updated by Brady Stroud [SSW] 1 year ago. See history
123
<introEmbed
body={<>
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
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.