Generating DDL › How to Create a Database › Set Generation Configuration Parameters › Include Drop Statements in DDL

Include Drop Statements in DDL

Many database management systems cannot create a database, table, or index if it already exists, and cannot create new databases unless a DROP statement is generated into the DDL. The DROP statement that appears in the generated DDL is a logical data definition statement that removes the description of a database or its components from the system. For each DBMS, you must include a DROP statement to recreate (regenerate) an existing database's components.

You can also specify generation of the DROP statement for one or more database components from the DDL Generation window. When a component is dropped, all data associated with that component is dropped as well.

Important! The DROP statement can delete a database and all of its data. If you need the data, back up the database before you DROP it.

Downstream Effects: If you are creating a new database remote file, do not generate DROP statements in the DDL. If DROP statements appear in a DDL remote file that was not previously installed on the remote platform, the implementation may fail. This occurs because the BT is attempting to delete a database that does not exist.