Using Code Templates in the SQL Editor

Go Up to Working With Code Workbench Code Templates

Code templates are complete code blocks that can be easily added to scripts with a few keystrokes. Templates let you define standard comment blocks or add common exit and error handling routines to new or existing objects.

1. Ensure that the Code Templates feature is enabled, a hot key designated, and that one or more templates have been defined. For access to more information on those tasks, see Working With Code Workbench Code Templates.
2. Open the SQL Editor and ensure there is an active datasource. For details, see Connected/Selected Datasource options.
3. Include one or more template shortcuts in a script.
4. At any time, press CTRL+SPACE. All instances of shortcuts are replaced by the associated, complete code template.

For related information, see the following topics:

• Enabling Code Templates - tells you how to turn on the Code Template feature.
• Defining the Hot Key for the Code Templates Dialog Box - tells you how to designate the keystroke that results in shortcuts being replaced by full code templates in the SQL Editor.
• Creating Code Templates - tells you how to create and maintain your list of code emplates and shortcuts.