Complete Compare: when a model modification causes a table to be dropped and then recreated, a temporary table is created using a RENAME in the DDL script. If I do NOT want to preserve the data, where do I turn on that option?
When you doing a Complete Compare and export your change, you need to select the Alter Script icon and then press Preview to get the database Schema Generation Preview window. Then you can check on the "Save Data" Box at the bottom to get to the Data Preservation Options Dialog. There, you can select the 'DO NOT Preserve Data' box.