Forward Engineer/Alter Script › Select Schema Generation Options

Select Schema Generation Options

Use the options on the Options tab in the Schema Generation dialog to select schema generation options.

To select schema generation options

1. Select Forward Engineer/Schema Generation on the Tools menu.

   The Schema Generation dialog opens on the Options tab.

2. Select the name of the current option set and choose from the following options:
   • Schema Generation

     Displays available schema generation groups from which you can select schema generation options.

   • Options

     Displays available schema generation options for the selected schema generation group. The target server you select determines which schema generation options you can select. For example, if your target server is Oracle, you can select View options to include CREATE VIEW statements in the DDL script. However, if your target server is FoxPro, you cannot select View options because FoxPro does not support views.

   • Database Template

     Displays the default database template for the selected target server, or the name of the customized template currently in use. Click Browse to change the template. Click Reset Template to restore the default template. For more information, see this topic: Using custom or default database templates during schema generation.

   • Filter

     Opens the Report Filter dialog to choose which tables you want to forward engineer.

   • Owner Override

     Opens the Owner Override dialog to set a global name override, or a name override for the listed object groups.

   • Preview

     Opens the Schema Generation Preview dialog to preview the schema DDL script generated for the current model based on the options you select.

   • Print

     Prints a copy of the schema DDL script.

   • Report

     Opens the Generate SQL Schema Report dialog to save the schema DDL script as a .ers or .sql text file.

   Click Generate to start the schema generation process for forward engineering or alter script generation or OK to save the changes and close the dialog.