SQL Server prevents saving the modified table structure solution _mssql

In our program development, we sometimes modify the table structure in the database because of the changing requirements. It may be the addition or decrease of the column, or modify the data type, or modify the column name, and so on. However, modifying the table structure is a risky operation, and by default, when you modify the table structure, the following prompt box pops up

The above illustration is the data type that modifies the column in the Deuser table (modified from varchar to int), and then the Prompt box that pops up when it is saved. What if we don't want to recreate the table and just want to modify its structure on the basis of the original?

The steps are as follows:

Step 1. Open SQL Server Management Studio

Step 2. Select Tools (Tool menu)

Step 3. Select options (option)

Step 4. Find Designers (designer)

Step 5. Select table and DB Designers (table and Database Designer) under designers

Step 6. Remove the check option on the right prevent saving changes that require table re-creation

Step 7. Save

The specific details are shown in the following illustration:

It is recommended that your novice database friend cancel this option when you use it by looking for "tools" on the menu bar in Management Studio and clicking on the following options to expand designers in the interface below, select Table Designer and Database Designer, and Prevent saving changes that require a table to be recreated "the check in front is aborted.

That's how SQL Server prevents you from saving changes that require you to recreate the table. I hope to help you, thank you for your reading.