Skip to content

Dictionary data

Relational databases often store related values in separate tables connected by foreign keys. In DBeaver, you can view and edit these values directly in the Value viewer. The panel shows a list of keys and their corresponding descriptions for quick lookup.

Tip

If you want to see full details of the referenced record, open the same foreign key in the References panel — it displays all columns from the related table.

Dictionary options

In the Value viewer, you can:

  • Edit value - change the current cell value directly.
  • Dictionary - view the referenced table for the foreign key. Click to open it in a new tab.

  • Define description - open a window where you can:

    • Choose columns for the dictionary description or set custom criteria.
    • Define a custom expression for descriptions.
    • Set a column delimiter.

  • Search - find dictionary entries by typing a value or part of a description string.

Dictionary preferences

You can customize how dictionaries behave in Value viewer:

  1. Go to Window -> Preferences -> Editors -> Data Editor -> Dictionaries.
  2. Configure the following options:
Setting Description
Keywords for dictionary description columns Define which keywords are used to identify description columns.
Maximum number of elements per page Set how many dictionary entries appear on one page.

These settings give you more control over how dictionary data is displayed and managed.

Info

For an overview of Panels, see Panels.