This is a classic. Microsoft SQL Server 2008 introduced a feature that prevents you from changing a table in the designer if it needs to be re-created. And whenever I get this I always forget where to turn this feature off. This time I recorded a 14-sec video that shows where this option is. Enjoy