Data definition language (DDL) defines the structure of a database, including rows, columns, tables, indexes, and so on.
You can generate the data definition of a database object using the Generate DDL wizard.
The DDL is generated into a .sql file in an Eclipse project, or is executed directly on the specified connection profile. You can use this .sql file to create the same database schema object in a different database, or you can generate the DDL of a complete database to create a new database on a different server.
You can edit the .sql file if you want to make changes.
The Generate DDL wizard provides:
- Multi-selection support – the Generate DDL wizard allows you to select other object instances of the same type in the same database, even if the Generate DDL context menu is invoked from
an object instance.
- Multi-SQL script
generation – provides the option to create one-to-one scripts, scripts by object type, and so on during
SQL script generation. You can also do limited schema
object versioning control. For example, you can create one
SQL DDL script for each stored procedural object and check those into
a CVS project, then use the CVS project for stored procedure
versioning control.