User cancelled out of save dialogue (MS Visual Database Tools)

小渣渣

The first dialog warns about the fact that the changes made cannot be saved  because they require the table to be re-created. This behavior is by default and happens under the following conditions:

TITLE: Microsoft SQL Server Management Studio
------------------------------

User cancelled out of save dialogue
(MS Visual Database Tools)

------------------------------
BUTTONS:

OK
------------------------------

- Adding a new column to the middle of the table
- Dropping a column
- Changing column nullability
- Changing the order of the columns
- Changing the data type of a column


Solution.


To change this behavior and let the designer made the changes for you, please do the following:

- On SSMS click on the Tools menu, then click Options.
- Click on Designers
- Clear the "Prevent saving changes that require table re-creation" check box.

顾言