You can create routine templates to use as a starting point
when you create stored procedures or user-defined functions with wizards.
About this task
The template pattern can contain any valid routine syntax
and can include variables. The variables from which you can choose
are specific to the context of the pattern.
Procedure
To create a routine template:
- Select .
- In the Preferences window, select .
- On the Templates page, click New.
- In the New Template window, specify the name of the template.
- Type a short description of the template.
- Type the template pattern. To add a variable at the insertion
point, click Insert Variable, and then select
the variable that you want in the pop-up window.
- Click OK. Your template
is added to the list on the Templates page in the Preferences window.
- Click OK in the Preferences window.
Results
The new template is now available for you to use in the routine
creation wizards.