Working with Data Models › Forward Engineer/Alter Script › Select Schema Generation Options › Define Schema Generation Materialized Query Table Options

Define Schema Generation Materialized Query Table Options

To define schema generation materialized query table 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 Materialized Query Table

   Include CREATE MATERIALIZED QUERY TABLE statements in the generated schema.

   Drop Materialized Query Table

   Include DROP MATERIALIZED QUERY TABLE statements in the generated schema.

   Create Procedure

   Include model-level stored procedures in the generated schema.

   Drop Procedure

   Include DROP PROCEDURE statements in the generated schema.

   Pre-Script

   Execute prescripts attached to the schema before generating the schema.

   Post-Script

   Execute postscripts attached to the schema after generating the schema.

   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.