Old problems that SQL Server cannot save after modifying table structure

After modifying the table structure can not be saved, this is every time you reload SQL Server will encounter problems, good memory is not as bad as writing, here to remember it.

When you save the modified table structure, you are prompted to "do not allow changes to be saved." Your changes require that the following tables be deleted and recreated. You have made changes to the label that cannot be recreated or enabled the "Prevent saving changes that require table re-creation" option. ”

As follows:

The workaround is also simple, in the menu in Microsoft SQL Server Management Studio, choose Tools, Options, designer, and remove the previous checkmark that prevents saving changes that require a table to be recreated.

Old problems that SQL Server cannot save after modifying table structure