Geek Answers Handbook

SQL server: cannot save / change table design

I try to make changes to an existing table and get this error when trying to save:

Saving changes is not allowed. The changes you made require the following tables to be deleted and recreated. You have made changes to the table that cannot be recreated or to enable the Deny saving changes that require the recreation of the table option.

I have only one data record in the database - would I delete it, resolving the problem, or will I have to recreate the tables, as the error suggests? (This is on SQL-Server 2008 R2)

+4
source share
3 answers

The following steps may require a recreation of the table:

, "" "", " ", " ". " ", , .

+10

,

  • SQL Server Management Studio (SSMS).
  • "" "".
  • "" "".
  • " , ", "".

enter image description here

+5
Goto -> Tools -> Options->Designers-> Warn on null primary keys and 
Warn about tables affected

uncheck the box and try again

0
source

More articles:


All Articles