Inserting Begin and End Scripts for Database Creation

In a database creation script, you can insert the following scripts:

Script	Where it is inserted
Begin script	Before the command that creates the database
End script	After the last command in the database creation script

You can use the following variables in these scripts:

Variable	Description
%DATABASE%	Name of the current PDM
%DATE%	Date of script generation
%DBMSNAME%	Name of the DBMS for the target database
%NAMESCRIPT%	Filename of script file
%PATHSCRIPT%	Filename and path of script file
%STARTCMD%	Command that runs the script
%AUTHOR%	Author of the current model

Select Model > Model Properties .
or

Right click the diagram background.

Select Properties from the contextual menu.

The model property sheet is displayed.
Click the Create tool next to the Database box.
A confirmation box is displayed asking you to commit the creation of the database script object.
Click Yes.
The database property sheet is displayed.
Type a name and code for the database.
Click the Script tab.
The Script tab opens to the Begin tab.
Type the DBMS-specific commands to insert in the beginning of the script.
Click the End tab at the bottom of the tab.
Type the DBMS-specific commands to insert at the end of the script.
Click OK in each of the dialog boxes.