If you remove one or more default templates from the list on the
SQL Editor - Templates page in the Preferences window, you can return them
to the list.
A default template is restored to its state at the time of its
removal. That is, if you modified a default template prior to removing it,
the modified version of the template is restored.
You can restore only
default templates. You cannot restore templates that you create or import.
You cannot restore removed default templates selectively. All of the removed
default templates are restored.
To restore removed SQL or XQuery templates:
- Click .
- In the navigation tree of the Preferences window, expand the Data node
and the SQL Editor node, and then click Templates.
- On the SQL Editor - Templates page, click Restore Removed. If the button is not available, no default templates are removed. The
default templates that you removed previously are listed on the Templates
page again.
- Click OK in the Preferences window.
The restored templates are available in your workbench for you to
use in the SQL editor.