SQL server is sometimes source of irritation! If you are not careful – you might run into this obstacle I just had today. Trying to edit a table definition directly in SQL Server Management Studio, I got the error message:
“Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.”
In itself – it is an okay error as we do not want to delete data (sometimes!). But where do you change this behavior when you actually do want to change a table definition and don’t care about the data inside the table. Well – uncheck this setting and you are good to go!