Notifications
Clear all
19/07/2020 8:00 pm
I want to change a database column in SSMS and get the following error message:
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the tables to be re-created.
19/07/2020 8:02 pm
In order to make changes to a table, you have to change an option in SQL Server Management Studio (SSMS).
-
In SSMS, in the main windows menu, choose Tools → Options… → Designers.
-
Uncheck the option ”Prevent saving changes that require table re-creation
