SqlServer 2008 Prevent Saving changes
February 27, 2011
When you modify a table in SqlServer and this change requires the table to be dropped and recreated, it’s necessary that SSMS is configured to allow this.
Go to SSMS/Tools/Options designers and uncheck this option.
See below