SQL Server Management Studio Tips - How to activate saving table modifications
Once you have created a table using Sql Server Management Studio, you have done changes the table structure, you want to save it.
But SSMS doesn’t allow you to do so.
You need to modify the configuration in Tools -> Options -> Designers and uncheck “Prevent saving changes that require table re-creation”.
I hope this post can do help to you!