You cannot save changes that would result in one or more tables being re-created

You cannot save changes that would result in one or more tables being re-created. You can override this behavior by changing your configuration options. Open the Tools menu, click Options.

Options link in tool tab , asp.net

 In the Options dialog box, expand the Database Tools node and click Table and Database Designers.

Database designer tools options

You can clear the "prevent saving changes that require table re-creation" check box and then retry the save operation. The save operation might take a long time because the data in the affected tables must be copied to temporary tables.

Your pending changes require the following tables to be dropped and re-created.
Posted on by Jacob Lefore | No comments

0 comments:

Post a Comment