SQL Server does not allow changes to be saved

Reprinted from Http://jingyan.baidu.com/article/b7001fe1767d970e7282ddd6.html

SQL Server error prompt: Saving changes is not allowed.

Your changes require that the following tables be deleted and recreated. You have made changes to a table that cannot be recreated, or you have enabled the "Prevent saving changes that require table re-creation" option.

Method/Step

1. 1

   Modify the data structure of the database, for example, to change varchar to nvarchar,sqlserver The following error message appears

   Steps to read
2. 2

   Click "Tools" → "Options" of SQL Server

   Steps to read
3. 3

   Click Designers, and then tick the block save changes required to recreate table check box. Modify SQL Server data structure later, you will not be prompted to save!

SQL Server does not allow changes to be saved