Monday, April 1, 2013

Prevent saving changes that require table-re-creation Solution

Hello folks,

While updating database table definition in Visual Studio Express you might have encounter a error like:

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

This problem usually occurs when "Prevent saving changes that require table-re-creation" option is checked/enabled, and in order to overcome this error we would need to disable this option.

Follow these simple steps to workaround this error

  1. Click on Tool from the menu bar
  2. Click on Options
       3. Now from left side select Table and Database Designer    
       4. Now from right side un-check Prevent saving changes that require table-re-creation
       5.Click on OK 
Now you update/save your changes, and you will not encounter this error again

If you have any further queries please post a comment

I hope it was informative for you and I would like to thank you for reading