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
Key | Command |
---|---|
Down | Move down one line |
Shift+Down | Extend selection down one line |
Alt+Shift+Down | Extend rectangular selection down one line |
Ctrl+Down | Scroll view down one line |
Up | Move up one line |
Shift+Up | Extend selection up one line |
Alt+Shift+Up | Extend rectangular selection up one line |
Ctrl+Up | Scroll 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 |
Left | Move left one character |
Shift+Left | Extend selection left one character |
Alt+Shift+Left | Extend rectangular selection left one character |
Right | Move right one character |
Shift+Right | Extend selection right one character |
Alt+Shift+Right | Extend rectangular selection right one character |
Ctrl+Left | Move left one word |
Ctrl+Shift+Left | Extend selection left one word |
Ctrl+Right | Move right one word |
Ctrl+Shift+Right | Extend selection right one word |
Ctrl+\ | Move right one word part |
Ctrl+Shift+\ | Extend selection right one word part |
Alt+Home | Move to start of display line |
Home | Move to first visible character in document line |
Shift+Home | Extend selection to first visible character in document line |
Alt+Shift+Home | Extend rectangular selection to first visible character in document line |
End | Move to end of document line |
Shift+End | Extend selection to end of document line |
Alt+Shift+End | Extend rectangular selection to end of document line |
Alt+End | Move to end of display line |
Ctrl+Home | Move to start of document |
Ctrl+Shift+Home | Extend selection to start of document |
Ctrl+End | Move to end of document |
Ctrl+Shift+End | Extend selection to end of document |
PgUp | Move up one page |
Shift+PgUp | Extend selection up one page |
Alt+Shift+PgUp | Extend rectangular selection up one page |
PgDown | Move down one page |
Shift+PgDown | Extend selection down one page |
Alt+Shift+PgDown | Extend rectangular selection down one page |
Del | Delete current character |
Backspace | Delete previous character |
Ctrl+Backspace | Delete word to left |
Ctrl+Del | Delete word to right |
Ctrl+Shift+Backspace | Delete line to left |
Ctrl+Shift+Del | Delete line to right |
Ctrl+Shift+L | Delete current line |
Ctrl+L | Cut current line |
Ctrl+Shift+T | Copy current line |
Ctrl+T | Transpose current and previous lines |
Ctrl+A | Select all |
Ctrl+D | Duplicate selection |
Ctrl+U | Convert selection to lower case |
Ctrl+Shift+U | Convert selection to upper case |
Ctrl+X | Cut selection |
Ctrl+C | Copy selection |
Ctrl+V | Paste |
Ins | Toggle insert/overtype |
Return | Insert newline |
Tab | Indent one level |
Shift+Tab | De-indent one level |
Esc | Cancel |
Ctrl+Z | Undo last command |
Ctrl+Y | Redo last command |
Ctrl++ | Zoom in |
Ctrl+- | Zoom out |
Ctrl + F | Open the Find dialog (future version 3.12) or the search bar in the Execute SQL editors |
Ctrl + H | Open the Find/Replace dialog |
当前内容版权归 sqlitebrowser 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 sqlitebrowser .