SQL scripts generated for the nodes have variable definitions that provide object names for the public objects created by the scripts. The master script invokes all the underlying node level scripts in proper order. Therefore, all variable definitions must be defined in the master script.
The following variables are supported:
Variables that allow you to change the name of the objects that are input to the node level scripts, such as tables or views, and models. By default, these names are the original table or view names, and model names.
Variables that allow you to change the name of the Control table. By default, the name of the Control table is the workflow name.
Variables that indicate if named objects should be deleted first before they are generated by the script.
Parent topic: Generating SQL Script Files from the Workflow