If a template exists of the correct Type and Target DB, templates can be specified and evaluated as follows:

Operation

Location to Specify the Template

Alter Table DDL

Connection Properties > Target Settings > Default Table Alter DDL Template

Create DDL

Table Properties > Storage > Create DDL Template Connection Properties > Target Settings > Default Table Create DDL Template Connection Properties > Target Settings > Default View Create DDL Template

Create Index DDL

Connection Properties > Target Settings > Default Index Create DDL Template

Drop Index DDL

Connection Properties > Target Settings > Default Index Drop DDL Template

Export Script

Export Object Properties > Script Template

Load Script

Load Table Properties > Script Template Connection Properties > New Table Default Load Script Template

Update Procedure

When building the Update Procedure, specify a template to use in the Template drop-down field of the Update Build Option > Processing tab.

Custom Update Procedure

Table Properties > Custom Procedure

Update Script

Table Properties > Update Script

Post Load Procedure

Load Table Properties > Post Load Procedure

Post Load Script

Load Table Properties > Post Load Script

To check which Operations are supported by Templates on your Target database, refer to Templates for details.

  • The template of the right type and database controls the availability of the template options above, e.g. the template selection fields are only available if valid templates exist.
  • Most of the default settings for Templates are configurable in the Connection Properties > Target Setting tab. Refer to Connection Target Settings for details.
  • The template object context menu that is displayed when you right click a Template object from the Objects list on the left pane provides a Usage Report option, which enables you to list the table objects that are currently associated with the selected template. Refer to Working with Objects > Templates for details.
  • Additional host script language types that can be applied to templates can be defined in RED. Refer to Host Script Languages for details.