Customizing Scripts

You can customize scripts as follows:

Insert scripts at the beginning and end of database creation script
Insert scripts before and after a table creation command

Customizing a creation script allows you to add descriptive information about a generated script, or manipulate the script in such a way that is not provided by PowerDesigner.

The Script tab provides tools to help edit scripts:

Tool	Description	Keyboard shortcut
	Editor context menu	Shift+F11
	Edit With. Opens the script in your preferred editor (see Core Features Guide > Modeling with PowerDesigner > Customizing Your Modeling Environment > General Options > Text Editors)	Ctrl+E

Examples

If a development project archives all the database creation scripts that are generated, a header script can be inserted before each creation script, which may indicate the date, time, and any other information specific to the generated script.

If an organization requires that generated scripts are filed using a naming system which may be independent from a script name, a header script could direct a generated script to be filed under a different name than the name indicated in the creation script.

Access rights can be added as a footer to a table creation script.

Inserting Begin and End Scripts for Database Creation
In a database creation script, you can insert a Begin script before the command that creates the database and an End script after the last command in the database creation script.
Inserting Begin and End Scripts for Table and Tablespace Creation
For each table and tablespace, you can insert a Begin script after the table title and an End script after the table or tablespace creation command.

Parent topic: Generating a Database from a PDM