Select Settings | Options | Physical Model | particular database | Alter Script Settings area for new checkbox: Use Temporary Tables to Preserve Data
This option should be checked. If checkbox is cleared, a sequence of commands DROP TABLE / CREATE TABLE will be generated instead of temporary tables.
These will be the default settings for the Change Script, however, they can also be changed when running the Change Script Wizard:
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center