“Prevent saving changes that require the table to be re-created” negative effects

Tools –> Options –> Designers node –> Uncheck “ Prevent saving changes that require table recreation “.