To fix this in Management Studio, go to
Tools -> Options then go to the Designer Page and uncheck "Prevent saving changes that require table re-creation".
Tools -> Options then go to the Designer Page and uncheck "Prevent saving changes that require table re-creation".