I know we have all had this at least once. We tend to fix it and forget it. I had it today at work and had to look it up. We all know what that means, its going in my e-Brain.

This is for when you design a table in SSMS (SQL Server Management Studio) and when you try to save the changes you cannot. You get a message like the one below.

The fix is really simple of course. In SSMS go to your Tools, and then Options. In that dialoge box that comes up go to Designers. There you will see a checkbox for

Prevent saving changes that require table re-creation

Remove that check mark and click O.K. You will be good to go. Dropping and re-creating tables as needed when you click save.