Setting general preferences for DDL generation

Use the DDL Generation page in the Preferences window to set general preferences for how DDL scripts are generated by the workbench.

About this task

You can set global preferences to control how DDL scripts are generated by the workbench. These preferences are used to set the defaults for DDL generation:
  • From the Generate DDL wizard
  • From the compare editor

Procedure

To set general preferences for DDL generation:

  1. Click Window > Preferences from the main menu.
  2. Expand the Data Management node to see available options.
  3. Click DDL Generation.
  4. Modify the settings. You can select to quote object identifiers or qualify database object names by default.
  5. Click OK.

Results

The next time that you generate a DDL script, the default options that you selected are used.

Feedback