返回
-
标题
Generate Alter script creates drop and create table instead of an alter table with temporary table. How to avoid this? -
说明
Generate Alter script creates DROP and CREATE TABLE instead of an ALTER and create temporary table (to preserve data) How to avoid this? -
解决办法
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:
