Preferences window - SQL and XQuery Editor - Templates page

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.

Feedback