MSSQL · prevent saving configuration changes that require the table to be recreated

Time:2021-7-26
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.
MSSQL · prevent saving configuration changes that require the table to be recreated
MSSQL · prevent saving configuration changes that require the table to be recreated

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.

MSSQL · prevent saving configuration changes that require the table to be recreated
MSSQL · prevent saving configuration changes that require the table to be recreated

b) Renderings

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.

MSSQL · prevent saving configuration changes that require the table to be recreated

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.

Recommended Today

VBS obtains the operating system and its version number

VBS obtains the operating system and its version number ? 1 2 3 4 5 6 7 8 9 10 11 12 ‘************************************** ‘*by r05e ‘* operating system and its version number ‘************************************** strComputer = “.” Set objWMIService = GetObject(“winmgmts:” _  & “{impersonationLevel=impersonate}!\\” & strComputer & “\root\cimv2”) Set colOperatingSystems = objWMIService.ExecQuery _  (“Select * from […]