Previous Topic: Create a New Template FileNext Topic: Customize a Template File During Schema Generation


Customize a Template File

You can customize a default template file in the Template Editor. Your customizations can be used to change syntax or add to or modify the options in the Forward Engineer and Alter Script dialogs. For example, you can add or modify templates to navigate or extract content from your model.

Each database has a corresponding forward engineering template file. The template files are automatically installed to the \Program Files (x86)\erwin\Data Modeler r9\BackupFiles\Templates folder. These template files are quite extensive so they cover all of the SQL required for erwin Data Modeler's processes. Therefore, when you customize a template file, you should begin with the default template file and modify it for your specific needs. Save the template file using either the existing file name or providing a new name, and then associate it with a model for schema generation tasks.

Note: When you save a forward engineering template file using the default file name provided in this product, you are overwriting the template file. If you need to revert to the original, unchanged forward engineering template file, read-only backup copies are located in the \BackupFiles\Templates folder.

To customize a template file

  1. Select Forward Engineer, Forward Engineering Templates from the Actions menu (in either a physical or logical/physical model).

    The Template Editor opens.

  2. Select the template file that you want to customize. By default, the Template Editor opens using the default template file for the target database of your model. If you want to use a different template file, click the Open Template File icon to open the Open dialog and select the template file that you want.
  3. Customize the template using any of the following features in the Template Editor:
  4. Click the Save Template File icon after you complete customizing the template.
  5. Enter a file name to save it as a new (*.fet) template file or use the existing file name and click Save.

The new, customized template is ready to use for schema generation tasks.

More information:

Sample Context

Templates Pane

Template Source Pane

Macros Pane

Expanded Text Pane