Inserting Begin and End Scripts for Table Creation

For each table, you have the option to insert the following scripts:

Script

Where it is inserted

Begin script

Immediately before the table creation command (after the table title)

End script

Immediately after the table creation command

These scripts can appear in database creation scripts and database modification scripts.

You can use the following variables in these scripts:

Variable

Description

%COLNLIST%

Column list

%DATABASE%

Code of the current PDM

%DATE%

Date of script generation

%DBMSNAME%

Code of the DBMS for the target database

%NAMESCRIPT%

Filename of script file

%OWNER%

Table owner

%OWNERPREFIX%

Owner prefix of table owner

%PATHSCRIPT%

Filename and path of script file

%STARTCMD%

Command that runs the script

%TABLE%

Name or code of current table (based on display preferences)

%TCODE%

Code of the current table

%TLABL%

Label of the current table

%TNAME%

Name of the current table

%AUTHOR%

Author of the current model
  1. Double-click a table symbol.

    The table property sheet is displayed.

  2. Click the Script tab.

    The Script tab opens to the Begin tab.

  3. Type the DBMS-specific commands to insert in the beginning of the script.
  4. Click the End tab at the bottom of the tab.
  5. Type the DBMS-specific commands to insert at the end of the script.
  6. Click OK.
Parent topic: Customizing Scripts

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com