Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Define Oracle Script Templates › Pre and Post Scripts Editor - General Tab

Pre and Post Scripts Editor - General Tab

Use the General tab to modify general information for a script. The following describes the options for the General tab:

Script Type

Select one of the following script types:

Model-level

Select to create a model-level script. A model-level script is executed either before or after the schema generation script.

Table-level

Select to create a table-level script. A table-level script is included either before or after the CREATE TABLE statement.

Generate

Select this check box to generate the script to the schema when you Forward Engineer. Clear this check box to not generate the script to the schema. If you select this option you must also select a Generation Option.

Generation Option

Select one of the following generation options:

Pre-Creation

Select this option to include the expanded code for the script before all other statements in the schema script (model-level script), or to display the script before the CREATE TABLE statement in the schema generation script (table-level script).

Post-Creation

Select this option to include the expanded code for the script after all other statements in the schema script (model-level script), or to display the script after the CREATE TABLE statement in the schema generation script (table-level script).