When updating a Foreign Key constraint via management studio design view and an error occurs it deletes the FK

I am updating tables via Management studio using the design view.

When I attempt to make changes to a FK and an error occurs e.g. I try to set the cascade Delete rule to Set NULL I then save the changes and receive an error saying this is not valid due to multiple cascade paths.

What I expect to happen is for the changes to be rolled back but instead when I look in my constraints the FK that I was trying to update has been deleted, and I have to recreate them.

Is there a way to setup Management studio so it rollback these changes when an error occurs?

Source: sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.