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.