sql server management studio prevent option off

Go to Tools-> Options -> Designers -> Table and Database Designers
checkbox "Prevent saving changes that require table recreation"

http://www.sql-server-performance.com/faq/saving_changes_not_permitted_p1.aspx