Generating Database Definitions to a File

Create a SQL file containing the CREATE and DROP statements that you can run against an online database schema.

Note: If you have made changes to tables that have foreign keys, it is possible that the foreign keys will be dropped when you generate your changes to the database. For more information, refer to Offline Tables and Foreign Keys.

To create the file:

In the navigator, expand the workspace and project.
Right-click an offline schema and choose New to display the New Gallery.
From the New Gallery, expand Database Tier , and select Offline Database.
Select SQL Generated from Offline Database Objects wizard to launch the Generate SQL from Offline Database Objects wizard.
In the pages of the wizard enter parameters and select options to define the table. For information about how to fill in these values, click Help in the dialog.
On the Generate Options page select CREATE (or replace) the chosen objects. Click Next.
On the SQL Script Options page specify details for the generated file, then click Next.
On the Finish page, click Finish to create the file.

Context Menu Shortcut:

In the navigator, right-click one or more offline table definitions and choose Generate or Reconcile Objects
or
On the database diagram select one or more tables, right-click and choose Generate | Data Definition Language.