Forward Engineer/Alter Script › Select Schema Generation Options › Define Schema Generation View Options

Define Schema Generation View Options

To define schema generation view options

1. Click Forward Engineer, Schema... on the Actions 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:

   CREATE VIEW

   Include Create VIEW statements for each selected view in the generated schema.

   DROP VIEW

   Execute DROP VIEW statements before executing CREATE VIEW statements when generating the schema. A DROP VIEW statement is executed for each CREATE VIEW statement in the schema.

   Pre-Script

   Execute prescripts attached to a view immediately before generating the view.

   Post-Script

   Execute postscripts attached to a view immediately after generating the view.

   Create Macro

   Define a set of statements that are frequently used, or that perform a complex operation. The statements in the macro body are submitted when the macro is invoked by a subsequent EXECUTE statement. This option is available only for Teradata.

   Drop Macro

   Remove a macro definition from a database. This option is available only for Teradata.

   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.