Prevent saving changes that require the table to be re-created
You are modifying a table, using
Design table in SSMS, and want to generate a change script (or maybe you want to save your change)
Table Designer → Generate Change Script
Sql Server Management Studio (SSMS) produces this error:
Saving changes is not permitted. The changes you have made require the following changes to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled te option Prevent saving changes that require the table to be re-created.
To enable this option, go to:
Tools → Options → Designers → Table and Database Designers → Table Options Prevent saving changes that require table re-creation