Introduction to common operations of Dbeaver

This article mainly explains the "introduction to the common operation of Dbeaver". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "the introduction to the common operation of Dbeaver".

Dbeaver is a free and open source (GPL) universal database tool for developers and database administrators.

In the development process can greatly improve our work efficiency, let me describe the functions I use on a daily basis:

1: compared with plsql, Dbeaver does not have the function of right-clicking to view table comments directly, but Dbeaver provides a "open declaration" function, in which you can view some more practical contents: table column comments, create statements to create the table:

2: in the case of general development, the number of data items that need to be queried will not be so large, and the query speed is required to respond quickly. In order to make the Dbeaver query faster, you can set the number of data returned for each query, and set 20 entries: window-preferences.

3: to make it easier to write SQL statements, Dbeaver provides "template function", which can automatically generate some commonly used SQL statement blocks. After configuration, enter the name and double-click the tab key to call out the SQL template:

4: convert the query results to various formats. Right-click on the query result set-Advanced copy:

Thank you for your reading, the above is the content of "introduction to the common operation of Dbeaver". After the study of this article, I believe you have a deeper understanding of the introduction of the common operation of Dbeaver, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!