|Reading time|||0.23 minutes||word count|||370.4 characters|
|primary coverage|||1. Introduction & background|
|“MSSQL · prevent saving configuration changes requiring table re creation”|
|Author||| SCscHero||Writing time||| 2021/7/15 PM9:0|
|Article type|||Series||Degree of completion|||Completed|
|motto||Every great cause has a trivial beginning.|
1、 Introduction & background Completion: 100%
a) Dealing with problems
When modifying the properties of the columns in the table in view, the following dialog box pops up: changes are not allowed to be saved.
- [Chinese version]The changes you have made require the following tables to be deleted and recreated. You have made changes to tables that cannot be recreated or enabled the block save options that require tables to be recreated.
- [English version]Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.
b) Response scenario
Modify table attributes by GUI in SSMS, such as auto increment and default value of columns.
2、 Solution Completion: 100%
a) Detailed steps
Enter the following window through the menu “tools” – > “options”. After selecting the design in the left menu, check the check box as shown in the figure.
After modifying the configuration, use the GUI to design the table again. It can take effect directly when saving, or there is an OK button in the pop-up dialog box.
3、 Statements and references Completion: 100%
Original blog post, please do not reprint without permission.
If you are helpful, you are welcome to like, collect and pay attention. If you have any questions, please comment! If you need to contact the blogger, you can write scschero directly.