Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Wednesday, 25 February 2015

Problem saving changes in database table Microsoft Visual Studio 2010

Posted by with No comments
ERROR :
“You cannot save changes that would result in one or more error tables being re-created.You can override this behavior by changing your configuration options…” shown in figure 1
 (figure 1)
SOLUTION TO THIS PROBLEM :
Disable “Prevent saving changes that require the table re-creation” 
Step by step guide :
1. Click on Tools menu and then click on Options shown in figure 2

(figure 2)
2. Once you are in the Options menu , click on Database Tools , click on Tables and Database Designers and then untick Prevent saving changes that require table re-creation shown in figure 3