Document Outline window

The Document Outline window shows a structured, hierarchical view of the SQL script or document you’re working on. It helps you navigate large SQL files by listing report elements, queries, subqueries, and individual clauses in an organized tree view.

You can use the Document Outline window to:

  • View the structure of scripts, queries, or reports.
  • Navigate large SQL documents and complex stored procedures.
  • Move to the object location in the script.
  • Navigate between queries, subqueries, and clauses.
  • Filter elements in the Document Outline window.

Elements appear as expandable and collapsible nodes in a hierarchical tree view.

Open the Document Outline window

To open the Document Outline window, select View > Document Outline.

Open the Document Outline window

Toolbar

The toolbar appears above the search box.

Document Outline toolbar

The table describes the available options.

Icon Name Description
Refresh Refresh Refreshes the list of elements in the tree.
Toggle automatic refresh Toggle automatic refresh Turns on (when enabled) or turns off the automatic updating of the tree when the underlying data changes.
Collapse all Collapse all Collapses all nodes in the tree.

Shortcut menu commands

Right-click a tree element or node and select the required command.

The table describes the available commands.

Name Description
Collapse Collapses the selected expanded node in a hierarchical view.
Expand Displays the full contents of the selected collapsed node.
Full Expand Displays the full contents of all collapsed nodes.
Full Collapse Collapses all expanded nodes in a hierarchical view.

Navigate to the object in the script

To navigate to the object in the script, click or double-click it in the Document Outline window. The element will be highlighted in the SQL document.

Navigate to the object in the script

Find in Document Outline

To find an element, start typing in the search box. The matching text will be selected in yellow.

Note

The search is case-insensitive.

Find in Document Outline

To clear the search results, select Clear Filter Clear Filter in the search box.

In the search box, you can use the following keyboard shortcuts:

  • Ctrl+A to select all.
  • Ctrl+Left Arrow (←) to move the caret to the beginning of the word.
  • Ctrl+Right Arrow (→) to move the caret to the end of the word.
  • Ctrl+Shift+Left Arrow (←) to select text from the current caret position to the beginning of the current word and move the caret to the beginning of the word.
  • Ctrl+Shift+Right Arrow (→) to select text from the current caret position to the end of the current word and move the caret to the end of the word.
  • Ctrl+Backspace to delete the word to the left of the cursor.

To select all text in the search box, right-click the search box and select Select All.