[SSW Rules] Relationships - Do you know to not use ON DELETE CASCADE clause when creating relationship?

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.

Tell a Friend about this

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:

Comments:

Navigate Between Rules

Rules To Better SQL Databases - Developers

Acknowledgements

Help and improve these rules

Nothing great is easy. The SSW rules are a great resource for developers all around the world.
However it’s hard to keep rules current and correct. If you spot a rule that is out of date, please email or if you are cool tweet me,or one of the people in above acknowledgements.

Adam Cogan

Our experience

SSW Consulting has over 25 years of experience developing awesome Microsoft solutions that today build on top of Angular, React, Azure, Azure DevOps (was TFS), SharePoint, Office 365, .NET Core, WebAPI, Dynamics 365 and SQL Server.

With 40+ consultants in 5 countries, we have delivered the best in the business to more than 1,000 clients in 15 countries.

How to get started

SSW will look at your Website Design and Development needs and help you design and implement an effective Website.

Call us on
+61 2 9953 3000 to get started!