SQL Server: Saving changes is not permitted because table will be re-created
Microsoft has added a setting to Management Studio to prevent us from re-create tables when we make changes to them. I don’t like this settings and it would have be much better if they said ‘This table will be re-created, are you sure you want to do that?” instead of just stop us from doing it.
There is an option to turn this off if you go to “Tools -> Options -> Designers -> Table and Database Designers” and the uncheck the checkbox “Prevent saving changes that require table re-creation”.
