Instant SQL View


The Instant SQL View combines functionalities of both the SQL Editor and the Table Editor.

Actions


Icon
Text
Key Shortcut
Description

Select Statement (Three Mouse Clicks) Ctrl+Shift+A Selects the SQL statement the cursor is currently positioned in.
Execute Execute
Ctrl+E
Execute the currently selected text (or all statements if none is selected) and open a new result tab in the result area.
Execute Reuse Viewer
Execute and Reuse Viewer
Ctrl+Shift+E
Execute the currently selected text (or all statements if none is selected) and reuse the previous result tab in the result area.
Execute Persist
Execute and Create Persistent Entry
Ctrl+Alt+E
Execute the currently selected text (or all statements if none is selected) and create a entry under the current database scope. This can be viewed and changed in the Tables View.
Toggle Panes
Toggle Panes

Toggle the view state of the result area and the SQL edit area from normal to maximized or invisible.
Select Connection
Select Connection

Press this to open a dialog from that you can choose the current database connection.
All Catalogs All Catalogs in Content Assist

If toggled, content assist shows catalogs if the JDBC driver for the currently selected database supports catalogs. Else the catalog that may have been selected in the URL is used by default and content assist does not show any catalog.


Scroll Next
Ctrl+Page Down Scrolls to the next rows in the result set.

Scroll Previous
Ctrl+Page Up Scrolls to the previous rows in the result set.

Copy
Ctrl+C Copies the selected row(s) to the clipboard.


Legal Notice