To fix this error in SSMS: At the top right of your studio go to Tools > Options.
Click on Designers and uncheck "Prevent Saving Changes that require table re-creation".
FYI, you should understand the implications of dropping and recreating your tables and this isn't always the best option for making table alterations.