Edit and delete drivers for databases

DBeaver user guide

Views
Database Navigator
Filter Database Objects
Configure Filters
Simple and Advanced View
Projects View
Project Explorer
Query Manager
Background Tasks
Database Object Editor
Properties Editor
Data Editor
Navigation
Data View and Format
Data Filters
Data Refresh
Data Viewing and Editing
Panels
Managing Charts
Data Search
SQL Generation
Working with spatial/GIS data
Working with XML and JSON
Managing Data Formats
Virtual column expressions
SQL Editor
SQL Templates
SQL Assist and Auto-Complete
SQL Formatting
SQL Execution
Variables panel
Query Execution Plan
Visual Query Builder
Script Management
Client Side Commands
Debug
PostgreSQL Debugger
ER Diagrams
Database Structure Diagrams
Custom Diagrams
Edit mode
Search
File Search
DB Full-Text Search
DB Metadata Search
Schema compare

Data compare

Bookmarks

Shortcuts

Cassandra

InfluxDB

SQLite Crypt

Informix

Enterprise Edition

DBeaver user guide 3/285

License management

License Administration
How to Import License
How to Reassign License

NOTE:

The installer does not change any system settings or the Java installation.

NOTE: Do not unzip the archive over a previous DBeaver version. If you already have any version of DBeaver extracted in the same location - remove it before unzipping the new version.

NOTE: All configurations, scripts and other necessary data are stored in a separate location (usually in the user`s home directory) so the program deinstallation does not affect them.

2. Execute dbeaver & .

RPM Package

Automatic updates

This feature is available only in Windows and macOS.

Edit menu contains global commands like Cut, Copy, Paste, and Delete targeted at the active element.

Navigate menu allows navigation through scripts and database objects.

Help menu contains links to information and help resources, as well as menu items to check the version number and availability of updates.

You can customize the menu bar and the list of menu items to display, for this, go to Window -> Customize Perspective -> Menu Visibility tab.

You can customize the toolbar, for this, go to Window -> Customize Perspective -> Tool Bar Visibility tab.

You can hide or show the toolbar in the application window. To do it, go to the Window menu, click Appearance -> Hide Toolbar / Show Toolbar.

There can be several views and editors opened simultaneously in the workspace but only one of them can be active at a time.

Close - to close the active window or tab in a tabbed window
Close Others (for editors and views that appear as tabs in tabbed windows) - to close all tabs of the current tabbed window except the active tab
Close Tabs to the Right / Left (also for tabbed windows) - to close all tabs of the current tabbed window that are located to the right / left of the active tab
Close All - to close all tabs of a tabbed window (close the window)

Maximizing, Minimizing and Restoring View and Editors All views and editors have the Close, Minimize and Maximize buttons:

Double-click the title bar of the view or editor.

On the Window menu, click Appearance -> Maximize Active View or Editor.

The shortcuts of views and editors may appear on the left or on the right shortcut bar depending on the latest docked position of the view or editor.

To minimize a view, do one of the following:
Click the Minimize button in the upper-right corner of the view.

For Database Navigator, Projects, and Project Explorer views, on the Window menu, just click the name of the view.

Some views open on demand, for example the Search view opens to show search results.

Database Navigator

The menu contains the following items:

The toolbar is located in the title bar of the window. Its buttons duplicate the menu items, except for the Active Project.

DBeaver user guide 10/285

Filter Database Objects

In the Database Navigator and Database Object Editor you can filter database objects to include or exclude some of them from the view. You can filter connections, schemas, tables, views, and procedures. A dots sign (...) next to the node`s name indicates that a

You can select the types of filtering objects in the drop-down list on the right. And also use the filter only for active connections.

1. Select several objects of the same type using Ctrl or Shift keys.

2. Right-click the selection, then click Filter, and then choose one of the options on the submenu:

DBeaver user guide 13/285

To reset such filters, right-click the parent (folder) node displaying the dots sign (...) , and then click Filter -> Clear filter.

3. If you want the filter to apply to all objects of a certain type, for example to all schemes, click Show global filter. Otherwise, the filter will apply only to the current object. NOTE: Once you apply the global filter, you cannot revert back to the local filer in the same window. To create a local filter, reopen the Filtering window, see Step 1.

4. For objects that you want to show, click Add next to the Include field and then, in the field itself, enter the name or combination of symbols to search. For objects that you want to hide, click Add next to the Exclude field and then, in the field itself, enter the name or combination of symbols to search. NOTE: You can use masks with % and * to replace one or more symbols and _ to replace one symbol in the search combination.

Projects View
You might need to classify and group database connections into projects. Projects store objects related not to a particular database but to all database connections. These are usually files stored on the file system.

ER Diagrams - contains ER diagrams that you can drag-and-drop here from other folders
Scripts – contains scripts that you can drag-and-drop here from other folders
The Projects view provides a toolbar and View menu which contain generic items. Each object in the tree has its own context menu. To open the view menu of the Projects view, click the View Menu button () in the upper-right corner of the window. The view menu contains the following items:

The toolbar is located in the title bar of the window, its buttons duplicate the view menu items except for the Refresh Projects one. To open the context menu for an object in the tree, right-click the object. For information about context menu items of all objects under the Connections node of the tree, please see Database Navigator. The context menus of other nodes in the tree contain some basic items for copy-pasting, renaming, deleting objects, managing their properties, creating folders, etc.

For information on how to change the view layout, please see the Application Window Overview article.

The title of the Project Explorer includes the name of the project: Project – [Project name]. General is a project that initially exists in the system by default.

To open the Query Manager, do one of the following:
Click the arrow next to the Transaction Log button in the toolbar and then click Query Manager on the dropdown menu:

You can modify the look of the Query Manager by filtering queries and setting the number of entries displayed per page, as well as specifying some storage settings, see the ‘Query Manager Properties’ section below.

To filter entries by object type, select or clear the checkboxes in the Object Types section. To filter entries by query type, select clear the checkboxes in the Query Types section.

To change the number of entries displayed per page, enter the new number in the Entries per page field.