================================
DBeaver 6.0.3 keyboard shortcuts
================================

First published at 6/5/2019 on https://defkey.com/dbeaver-shortcuts

DBeaver is a free and open source database management software for SQL. It
provides an editor that supports code completion and syntax highlighting.

DBeaver 6.0.3 has 55 shortcuts and we have listed all of them below.



SQL Editor
----------

Ctrl + Enter            Execute current query (*)
Ctrl + \                Execute current query in a new tab
Alt + X                 Execute current script (**)
Ctrl + Alt + '          Execute selected SQL expression and print results
Ctrl + Shift + E        Explain current query execution plan
Ctrl + Alt + Shift + X  Execute queries of current script simultaneously, showing results in
separate tabs
Ctrl + 9                Switch active connection (for SQL script)
Ctrl + Space            SQL completion proposals popup
Option + Space          SQL completion proposals popup
Ctrl + Alt + Space      SQL templates proposals popup
Ctrl + Shift + F        Format current script (**) using current formatter
Ctrl + /                Toggle single/multi line comment
Ctrl + Shift + /        Toggle single/multi line comment
Alt + Up arrow / Down arrow Jump to previous/next query
Ctrl + 6                Maximize editor/results panels
Ctrl + Shift + 6        Maximize editor/results panels
Alt + 6                 Maximize editor/results panels
Ctrl + Shift + 6        Minimize editor/results panels
Alt + 6                 Switch editor/results panels
Ctrl + Shift + X        Convert selected text into upper/lower case
Ctrl + Shift + Y        Convert selected text into upper/lower case


Data viewer
-----------

Tab                     Switch to record/grid mode
Ctrl + ~                Switch presentation (grid, plain text, json, etc.)
Ctrl + 1                Foreign keys navigation menu
Alt + Space             Navigate to the link in active cell
Alt + Left arrow        Navigate backward in history
Alt + Right arrow       Navigate forward in history
Ctrl + 2                Toggle sorting by current column
F11                     Current column filters menu
Ctrl + F11              Current column filter dictionary panel
F7                      Toggle right panels on/off
Ctrl + 7                Toggle right panels on/off
F5                      Refresh results (re-run query)


Data editor
-----------

Enter                   Activate inline editor
Shift + Enter           Open value editor dialog or separate value editor (for LOB values)
Del                     Delete row
Alt + Del               Delete row
Alt + Insert            Add new row
Ctrl + Alt + Insert     Copy current row
Esc                     Cancel changes in current cell/row


Database Navigator
------------------

F2                      Rename current element (if supported)
F4                      Open editor of selected element(s)
F5                      Refresh selected element(s)
Del                     Delete selected element(s) (if supported)
Ctrl + D                Add bookmark on selected element
Alt + Enter             Show properties of selected element
F3                      Open SQL editor for current connection (***). Shows script selector popup
Ctrl + [                Open SQL editor for current connection (***). Shows script selector popup
Ctrl + F3               Open new SQL editor for current connection (***). Always creates new script
Ctrl + ]                Open new SQL editor for current connection (***). Always creates new script
Ctrl + Enter            Open recent SQL editor for current connection (***). Opens last modified
script or creates a new script


Other
-----

Alt + ~                 Shows database tools context menu
Ctrl + 0                Switch active schema/catalog (available if SQL/database editor is open)
Ctrl + Shift + C        Advanced copy. Works in different contexts and performs "smart copy"
operation (usually with parameters)
Ctrl + Shift + V        Advanced paste. Same as "smart copy" but for "paste".


References
----------

    * - Current query is the query under cursor or the selected text. Query
is separated from other script queries by delimiter (; by default) or by
empty lines.

    ** - Current script is a set of all queries in the current SQL file. If
there is a text selection then only queries in this selection are
processed. Queries are separated from each other with a delimiter (; by
default).

    ** - Current connection is detected from active window and selection.
If active (focused) window is SQL editor or database object editor then
current connection is the same as in this editor. If active window is
database navigator then active connection is "owner" connection of
currently selected element. In other cases there is no current connection
and DBeaver will ask you to choose connection explicitly.

    Source


Last modified on (UTC): Thursday, December 19, 2019
Defkey © All rights reserved.