Include Automatically Generated SQL Script

You can include the automatically generated SQL script to the package template for the following artifacts:

• Database Lookup

• Manage List pointing to existing table

• Workflow with Database activity

To include the automatically generated SQL script

1. Select and right-click the artifact that you want to package, and then click Add to Package Template on the shortcut menu. In the Select Package Template page, select the Package Template.

   Or

   Create a new package template. For more information about creating a package template, see Creating a Package Template.

2. In the Include the automatically generated SQL Script section, perform one of the following:

   • Yes: Select this option if you want to include the automatically generated SQL Script for the artifact to the package template.

   • No: Select this option if you do not want to include the automatically generated SQL Script for the artifact to the package template.

3. Click Next. The Add to Package Template page appears.

4. In the Configuration section, click the artifact. The Settings page appears on the right pane.

5. In the Install tab:

   • The automatically generated SQL Script is displayed by default in the SQL script box, if the value of the Include the automatically generated SQL Script option is set to Yes.

   • The SQL script box is blank, if the value of the Include the automatically generated SQL Script option is set to No. If required, enter the SQL Script in the SQL script box.

6. Click Save Template.

For more information about adding artifacts to Package Template and validating SQL scripts, see Adding Artifacts to a Package Template and Validate SQL Scripts respectively.