DBeaver manual

快捷键

1.Ctrl+Alt+Shift+D

 to  add the selected elements into your bookmarks

2.Ctrl+\

To open query results in a new tab, use the following 
shortcut: 
3.Ctrl+Alt+Shift+B
To monitor database health you can open dashboard view using main toolbar 

4.Ctrl+7

You can turn on/off the right panels。

5.Ctrl+Alt+'.

To execute the selected SQL expression and print the results

6.Alt+X

To run the current SQL script use the following 

7.DBeaver Mock Data Generator
 when you need to create a huge quantities of realistic sample data for testing purposes and want to avoid tedious and time-consuming work of entering test data by hand.

8.F2
 to rename the selected element.

9.F5

To refresh query results in SQL Editor

9. Ctrl+Shift+F

In order to format SQL statements.

10.Ctrl+Alt+Space

To see available templates of SQL statements

11.Ctrl+Shift+Y

can convert the selected text into lowercase 

12. Ctrl+Shift+X

convert the selected text into uppercase

12.Ctrl+Alt+Shift+X

To execute queries of current script simultaneously and display the results in separate tabs

13. Alt+Down

To jump to the next query in the current SQL scrip

14.Alt+Up

To jump to the previous query in the current SQL script

15. Ctrl+F7

 iterate through the view windows of DBeaver interface.

Ctrl+Enter
.To execute current query

Ctrl+F11

to filter table rows by column value in 
Data Editor,use the following shortcut: Ctrl+F11. You can also open filter menu by pressing F11.

F7

You can turn on/off the right panels by pressing 

Ctrl+1

If you want to open foreign keys menu in Data Editor

Ctrl(Cmd) + Left click.

Choose the fully qualified name of the object in the SQL Editor and use Ctrl(Cmd) + Left click. This will take you to the object's tab. Works with tables, columns and procedures.

F4

In Database Navigator, press to edit properties of the selected element.

Ctrl+Alt+Enter

You can open SQL Console with the Ctrl+Alt+Enter shortcut. It's great for executing a query that you don't want to save in a file.

Ctrl+Shift+E 执行计划

To see the execution plan for the current query
Ctrl+F

to search for data in the current table.

语法

1.If you are not much familiar with SQL scripting, use Visual Query Builder tool. 

2.DBeaver allows viewing diagrams of existing tables and whole database schemas, see 
ER diagrams article.

3.All the errors that occur when running SQL scripts in DBeaver, can be observed in the 
Error Log view.The error log tracks SQL, permission and configuration errors.

4.Charts let you quickly and easily turn your SELECT queries' output into a colorized bar chart. 
Note: this feature is available only in DBeaver Enterprise Edition.

5.You can group several tasks into one composite task to easily execute a set of actions in one click. Note: this feature is available only in DBeaver Enterprise Edition
6.In SQL Editor you can press Ctrl/Option+Space after asterisk in a query like "SELECT * FROM tableName" or like "INSERT INTO tableName (*)" (brackets are important) and the asterisk will be replaced with a list of all 
table columns.

6.You can generate SQL statements (SELECT/INSERT/UPDATE/DELETE) based on selected rows. To generate SQL, right-click the selected rows ,then click Generate SQL and select one of the SQL commands you see.

7.In Data Editor, you can iterate through the view modes using the following shortcut: Ctrl+~

连接到SQLite， can't load driver class 'org.sqlite.JDBC' Error

C:\Users\appuser\AppData\Roaming\DBeaverData\drivers

Network unavailable: javax.net.ssl.SSLHandshakeException:PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

Can't create driver instance Error creating driver 'SQLite' instance.Most likely required jar files are missing.You should configure jars in driver settings.Reason: can't load driver class 'org.sqlite.JDBC' Error creating driver 'SQLite' instance. Most likely required jar files are missing.
You should configure jars in driver settings.Reason: can't load driver class 'org.sqlite.JDBC'.

下载最新的

sqlite-jdbc-3.39.3.0.jar，并在DBeaver加载。

连接到MS SQL Server, 更换驱动程序