There's a silly new default in SQL Server's Management Tools: When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the management tools will not allow you to save the changes.

The fix is: Go to

Tools | Options | Designers | Tables and Designers and uncheck the Prevent Saving Changes that require table re-creation option

More details