After 3+ years of not touching SQL Server, I managed to get my hands on SQL Server 2012. After creating two tables, and deciding to modify the first table schema, I get my first error message….
“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created….yada..yada…yada.”
So, sound coding methodologies suggest we analyze the change properly, and use caution while doing this. However, if you are starting off with a new project, there is always an option in the tools menu.
Tools > Options > Designers > Uncheck “Prevent saving changes that require table re-creation”