You will see the appropriate option on the dialog for creating DDL. If checked, EA will create a block of statements to DROP any existing entities (but only those that are in your model) before the block of CREATE statements.
I do not remember if this applies when generating DDL for a single table. It certainly does when creating DDL for a whole diagram. Make sure you have an open data model diagram. Then make sure you do not have any table(s) selected. [Just click on the diagram background, and any selection will be dismissed.] Then invoke the DDL generation and you should see the options.
Note: If this is the first time you've tried this, you might run into this snag. Make absolutely sure you have a DBMS selected for the tables. If you do not, then EA won't know what dialect of DDL it should generate, and your results will be somewhat anemic. If you do not see a DBMS on one of your Table Properties dialogs, don't panic. This can be solved without (all three of) L, G, and M.
Set the default DBMS for EA using the Settings | Database Datatypes dialog. You must have a project open to invoke this dialog, but EA will remember your choice in future. Use the Product Name drop-down to select your choice, then check the Set as Default button.
You can also set this - once again you must have an project open, even though the results will apply to all projects - from one of the options pages, though it is a bit counter intuitive. Open the Tools | Options | Source Code Engineering | Code Editors dialog. You will see a drop-down (without a check box) for DBMS products. The default will be the one shown when you open the dialog, and you change the result be selecting another product from the drop-down.
[Paolo might cite the two selection styles as yet another example of the EAUI (Enterprise Architect Unique Interface]; he would be correct. I have brought this up with Sparx, to no effect.]
David
