Rowan User Guide

Chapter 11

Keyboard shortcuts

Every command in Rowan has a shortcut. These are the defaults; you can change any of them in Settings > Keymap.

Change a shortcut#

  1. Open Settings (Ctrl,) and choose Keymap.
  2. Find the command by name or by its keys with Search shortcuts.
  3. Click its shortcut. When it reads Type shortcut…, press the new keys.
The Keymap page in Settings listing commands by area with their shortcuts
Settings > Keymap. Click a shortcut to record a new one.
  • A shortcut needs Ctrl or Alt, unless it's a function key such as F5.
  • Delete or Backspace clears a shortcut; Esc leaves it as it was. Reset beside a changed shortcut puts back its default, and Restore Defaults puts back all of them.
  • If the keys already belong to another command, Rowan asks whether to move them. The other command is left without a shortcut until you give it one.
  • Changes apply at once, in every window, menu and tooltip.
Note

Some shortcuts do different things in different places. CtrlI adds a row in the grid and beautifies SQL in the editor, and CtrlF opens filters in the grid and Find in the editor.

Tip

On keyboard layouts where CtrlAlt types characters, such as German or Polish, typing in a text field always wins: CtrlAlt with a key that types a character types it.

App#

ShortcutAction
Ctrl,Settings
CtrlNNew window (the connection list)
CtrlOOpen a .sql file
CtrlShiftONew SQL Viewer
CtrlShift/Report Bug & Feedback
CtrlQQuit Rowan

Workspace#

ShortcutAction
CtrlPOpen Anything
CtrlKOpen a database
CtrlShiftKOpen a connection
CtrlENew SQL editor tab
CtrlTNew tab
CtrlWClose tab
CtrlShiftTReopen closed tab
F2Rename tab
CtrlSCommit; with nothing pending, save the SQL editor's query
CtrlShiftPPreview pending SQL
CtrlShiftDeleteDiscard pending changes
CtrlZUndo
CtrlShiftZ or CtrlYRedo
CtrlRReload workspace (data and schema)
CtrlAltRReload current tab
CtrlShiftRReconnect
CtrlAlt.Disconnect
Ctrl.Process list, with your running query selected
CtrlShiftEExport tables
ShortcutAction
Ctrl] or CtrlTabNext tab
Ctrl[ or CtrlShiftTabPrevious tab
Ctrl1 … Ctrl9Tab by position
CtrlAlt] / CtrlAlt[ in the editorNext / previous pane
CtrlShiftDSplit pane right
CtrlShift] / CtrlShift[Next / previous workspace
CtrlShift\Show all workspaces
AltLeft / AltRightBack / forward
CtrlAlt[ / CtrlAlt] in a table tabShow data / structure

Panels#

ShortcutAction
Ctrl0Toggle left sidebar
Space (grid focused)Toggle right sidebar
CtrlAltCToggle console log
Ctrl`Toggle results pane
CtrlShiftFSearch the left sidebar
CtrlShiftHSearch query history
F11Full screen
ShortcutAction
SpaceOpen selected item
DeleteDelete selected tables (staged)
AltDeleteTruncate selected tables (staged)

Grid#

ShortcutAction
CtrlIAdd row
CtrlDDuplicate rows
CtrlCCopy rows
CtrlShiftCCopy selected cells
CtrlVPaste rows
CtrlShiftVPaste into selected cells
DeleteDelete rows
EnterEdit cell
TabNext cell; while editing, save and edit the next cell
CtrlEnter or middle-clickQuick Look
CtrlShiftO in Quick LookOpen in window
AltEnter or Alt-clickSet Value menu
CtrlUp / CtrlDownFirst / last row
CtrlLeft / CtrlRightPrevious / next page
CtrlFFilters
CtrlAltFColumn filter
CtrlAltSSort by several columns
CtrlGLimit and Offset
EscDeselect, or close Quick Look

Filter bar#

ShortcutAction
EnterApply this filter
CtrlEnterApply all checked filters
CtrlI / CtrlShiftIAdd / remove a filter
CtrlBCheck or uncheck a filter
EscClear the value; again to hide the bar

SQL editor#

ShortcutAction
CtrlEnterRun current statement or selection
CtrlShiftEnterRun all
CtrlI / CtrlShiftIBeautify / uglify
Ctrl/Line comment
CtrlAlt/Block comment
Ctrl= / Ctrl-Larger / smaller text
CtrlFFind
CtrlHFind and replace
F3 or CtrlGFind next
ShiftF3 or CtrlShiftGFind previous
CtrlShiftSSave to a .sql file
CtrlSpaceShow suggestions
EscHide suggestions; back to one caret
Ctrl-clickAdd a caret
Alt-dragRectangular selection
CtrlAltUp / CtrlAltDownCaret above / below
CtrlDSelect next occurrence
CtrlShiftLSelect all occurrences
CtrlF on a resultSearch and replace in the result