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