Removing SQL and XQuery templates

You can remove SQL and XQuery templates from the list of templates that are on the SQL Editor - Templates page in the Preferences window.

You can remove templates that you create or import. You can also remove default templates. If you remove default templates, you can restore them later. However, you cannot restore templates that you create or import.

To remove an SQL or XQuery template:

  1. Click Window > Preferences.
  2. In the navigation tree of the Preferences window, expand the Data node and the SQL Editor node, and then click Templates.
  3. On the SQL Editor - Templates page, click the template that you want to remove. If you want to remove more than one template, use the Ctrl or Shift key to select multiple templates.
  4. Click Remove.
  5. Click OK in the Preferences window.
The template or templates that you remove are no longer available for you to use in the SQL editor.
Parent topic: Templates for SQL and XQuery
Related tasks
Restoring removed SQL and XQuery templates
Related reference
Preferences window - SQL Editor - Templates page
Feedback