The Generate DDL wizard:
- Generates SQL CREATE, DROP, and COMMENT statements for existing databases and database objects which you can save as a text-formatted SQL script file (.sql extension, by default) in the Eclipse project. You can also open the script directly in the SQL Editor to edit the script and execute the generated DDL on a specified connection profile.
- Copies partial or entire database schemas between different servers on different connection profiles for copying database objects between different databases or users.
- Generates and executes DROP statements for several objects or object categories to save time when you need to drop several objects.
- Generates DDL that can be used as a backup of the current database structures in case you need to revert to a prior state. You can also modify the generated DDL by opening the .sql file in the SQL Editor.