DBeaver 6.0.3 keyboard shortcuts

DBeaver 6.0.3  

Zeynel Öztürk -
5 years ago
- Shortcuts

DBeaver will be even more useful if you use these shortcuts to edit your SQL queries. Most of the following commands are accessible from main menu, toolbar or right-click menu. In other words, keyboard shortcuts cover most of the commands available in the program. DBeaver recommends using right-click menu whevener possible, because it usually shows all actions accessible at the moment.

1
Ctrl + ⤶ Enter

Execute current query (*)

2
Ctrl + \

Execute current query in a new tab

0
Alt + X

Execute current script (**)

5
Ctrl + Alt + '

Execute selected SQL expression and print results

-1
Ctrl + ↑  Shift + E

Explain current query execution plan

0
Ctrl + Alt + ↑  Shift + X

Execute queries of current script simultaneously, showing results in separate tabs

1
Ctrl + 9

Switch active connection (for SQL script)

0
Ctrl + Space

SQL completion proposals popup

1
or ⌥ Opt + Space
2
Ctrl + Alt + Space

SQL templates proposals popup

1
Ctrl + ↑  Shift + F

Format current script (**) using current formatter

14
Ctrl + /

Toggle single/multi line comment

3
or Ctrl + ↑  Shift + /
1
Alt +   

Jump to previous/next query

-1
Ctrl + 6

Maximize editor/results panels

-4
or Ctrl + ↑  Shift + 6
3
or Alt + 6
1
Ctrl + ↑  Shift + 6

Minimize editor/results panels

0
Alt + 6

Switch editor/results panels

2
Ctrl + ↑  Shift + X

Convert selected text into upper/lower case

0
or Ctrl + ↑  Shift + Y

Advertisement

1
Tab

Switch to record/grid mode

1
Ctrl + ~

Switch presentation (grid, plain text, json, etc.)

0
Ctrl + 1

Foreign keys navigation menu

1
Alt + Space

Navigate to the link in active cell

0
Alt +

Navigate backward in history

1
Alt +

Navigate forward in history

1
Ctrl + 2

Toggle sorting by current column

0
F11

Current column filters menu

1
Ctrl + F11

Current column filter dictionary panel

0
F7

Toggle right panels on/off

0
or Ctrl + 7
0
F5

Refresh results (re-run query)

1
⤶ Enter

Activate inline editor

0
↑  Shift + ⤶ Enter

Open value editor dialog or separate value editor (for LOB values)

0
Del

Delete row

1
or Alt + Del
0
Alt + Insert

Add new row

0
Ctrl + Alt + Insert

Copy current row

1
Esc

Cancel changes in current cell/row

0
F2

Rename current element (if supported)

1
F4

Open editor of selected element(s)

0
F5

Refresh selected element(s)

0
Del

Delete selected element(s) (if supported)

2
Ctrl + D

Add bookmark on selected element

0
Alt + ⤶ Enter

Show properties of selected element

1
F3

Open SQL editor for current connection (***). Shows script selector popup

0
or Ctrl + [
4
Ctrl + F3

Open new SQL editor for current connection (***). Always creates new script

1
or Ctrl + ]
2
Ctrl + ⤶ Enter

Open recent SQL editor for current connection (***). Opens last modified script or creates a new script

0
Alt + ~

Shows database tools context menu

-1
Ctrl + 0

Switch active schema/catalog (available if SQL/database editor is open)

0
Ctrl + ↑  Shift + C

Advanced copy. Works in different contexts and performs "smart copy" operation (usually with parameters)

0
Ctrl + ↑  Shift + V

Advanced paste. Same as "smart copy" but for "paste".

Advertisement

    * - 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

Share this page on:
Is this page helpful?
0 0

Program information

Program name: DBeaver 6.0.3 DBeaver 6.0.3 (Developer tools)

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

Web page: dbeaver.com

Last update: 12/19/2019 12:23 PM UTC

How easy to press shortcuts: 79%

More information >>

Shortcut count: 55

Platform detected: Windows and macOS mixed

Similar programs




What is your favorite DBeaver 6.0.3 hotkey? Do you have any useful tips for it? Let other users know below.


 

dbeaver-postgresql OP says : 24 months ago 3/25/2022 4:05 PM
Ctrl+6 close result - nice shortcut.
But how to close "Problems" panel?
It is really annoying.