Use this page to review and maintain the SQL and XQuery templates
that you can use when you specify SQL and XQuery statements in the SQL and XQuery editor.
- Name
- Identifies the template. The name of the template
and its description are displayed in the content assist window. If the
check box that is next to the name is selected, the template is enabled and
is available for displaying in content assist.
- Context
- Indicates whether it is an SQL template or an
XQuery template.
- Description
- Briefly describes the template. The name of the
template and its description are displayed in content assist.
- Auto Insert
- If this field displays the value on and
the template name is unique, the template is automatically inserted in your
statement after you type the template name in the editor and press Ctrl +
Space.
- New
- Opens the New Template window, where you can specify the information for
a new template.
- Edit
- Opens the selected template in the Edit Template window, where you can
modify the template information.
- Remove
- Deletes all of the selected templates.
- Restore Removed
- Returns to the list all of the default templates that you have removed.
- Revert to Default
- Restores the original pattern to the selected default templates that you
have changed.
- Import
- Adds the templates in an .xml file to the list of available templates.
- Export
- Copies the selected templates to an .xml file. so that you can share the
templates with your team members.
- Preview
- Shows the pattern for the selected template.
- Restore Defaults
- Deletes all added and imported templates, and reverts all of the changed
default templates to their original pattern.