Tools->Options menu.
Under the Designers page, uncheck the option "Prevent saving changes that require table recreation".