Abstract

This Wiki page aims at listing the more ‘hidden’ keyboard shortcuts. By this I mean those shortcuts that aren’t obviously visible in the menus (e.g. Ctrl + N for a new database), that aren’t simply Alt accelerators (e.g. Alt + E for clicking the button with the underlined E), and that aren’t typical for all GUI application (e.g. Tab for changing focus).

Mac users have to press ⌘ instead of Ctrl

Main window

  • Alt + 1 switches to the Database Structure tab.
  • Alt + 2 switches to the Browse Data tab.
  • Alt + 3 switches to the Edit Pragmas tab.
  • Alt + 4 switches to the Execute SQL tab.

Database Structure tab

  • Ctrl + R and F5 refresh the database structure.

Browse Data tab

  • Ctrl + R and F5 refresh the currently browsed table.
  • Ctrl + “ duplicates the currently selected record.
  • Ctrl + ‘ copies the data from the cell above the current (future version 3.11).
  • Ctrl + PageUp and Ctrl + PageDown switch the currently browsed table to the previous or the next table.
  • Delete and Backspace delete the content of the current cell(s), setting it to an empty string.
  • Alt + Delete and Alt + Backspace delete the content of the current cell(s), setting them to NULL.
  • Tab moves to the next cell when the table browser is focused. When being on the last cell, a new row is inserted automatically.

Edit Pragmas tab

  • Ctrl + R and F5 refresh the pragma list.

Execute SQL tab

  • Ctrl + Return executes the SQL commands.
  • Ctrl + R and F5 execute the SQL commands.
  • Shift + F5 executes the SQL commands on the current line only.

Edit dialog and edit pane

  • Ctrl + Return clicks the Apply button.
  • Insert toggles overwrite mode in both text editor and hex editor.
  • Ctrl + F Opens the Find dialog (future version 3.12).
  • Ctrl + H Opens the Find/Replace dialog (future version 3.12).

Edit Table dialog

  • Ctrl + Return clicks the OK button.

SQL, JSON and XML editors

KeyCommand
DownMove down one line
Shift+DownExtend selection down one line
Alt+Shift+DownExtend rectangular selection down one line
Ctrl+DownScroll view down one line
UpMove up one line
Shift+UpExtend selection up one line
Alt+Shift+UpExtend rectangular selection up one line
Ctrl+UpScroll view up one line
Ctrl+]Move down one paragraph
Ctrl+Shift+]Extend selection down one paragraph
Ctrl+[Move up one paragraph
Ctrl+Shift+[Extend selection up one paragraph
LeftMove left one character
Shift+LeftExtend selection left one character
Alt+Shift+LeftExtend rectangular selection left one character
RightMove right one character
Shift+RightExtend selection right one character
Alt+Shift+RightExtend rectangular selection right one character
Ctrl+LeftMove left one word
Ctrl+Shift+LeftExtend selection left one word
Ctrl+RightMove right one word
Ctrl+Shift+RightExtend selection right one word
Ctrl+\Move right one word part
Ctrl+Shift+\Extend selection right one word part
Alt+HomeMove to start of display line
HomeMove to first visible character in document line
Shift+HomeExtend selection to first visible character in document line
Alt+Shift+HomeExtend rectangular selection to first visible character in document line
EndMove to end of document line
Shift+EndExtend selection to end of document line
Alt+Shift+EndExtend rectangular selection to end of document line
Alt+EndMove to end of display line
Ctrl+HomeMove to start of document
Ctrl+Shift+HomeExtend selection to start of document
Ctrl+EndMove to end of document
Ctrl+Shift+EndExtend selection to end of document
PgUpMove up one page
Shift+PgUpExtend selection up one page
Alt+Shift+PgUpExtend rectangular selection up one page
PgDownMove down one page
Shift+PgDownExtend selection down one page
Alt+Shift+PgDownExtend rectangular selection down one page
DelDelete current character
BackspaceDelete previous character
Ctrl+BackspaceDelete word to left
Ctrl+DelDelete word to right
Ctrl+Shift+BackspaceDelete line to left
Ctrl+Shift+DelDelete line to right
Ctrl+Shift+LDelete current line
Ctrl+LCut current line
Ctrl+Shift+TCopy current line
Ctrl+TTranspose current and previous lines
Ctrl+ASelect all
Ctrl+DDuplicate selection
Ctrl+UConvert selection to lower case
Ctrl+Shift+UConvert selection to upper case
Ctrl+XCut selection
Ctrl+CCopy selection
Ctrl+VPaste
InsToggle insert/overtype
ReturnInsert newline
TabIndent one level
Shift+TabDe-indent one level
EscCancel
Ctrl+ZUndo last command
Ctrl+YRedo last command
Ctrl++Zoom in
Ctrl+-Zoom out
Ctrl + FOpen the Find dialog (future version 3.12) or the search bar in the Execute SQL editors
Ctrl + HOpen the Find/Replace dialog