Data Editor and Viewer

The settings on this page define how table data is shown and modified in your database consoles, Hibernate and JPA consoles, data editors, and so on.

Option	Description
Use custom font	Set the dedicated font for your data. The font is applied for query results and data editor, not for query consoles and your SQL files.
Alternate row colors	Select this checkbox to make the table row colors alternate between two kinds of colors.
Show boolean values as	Set how you want to display boolean values in the data editor. You can select between the following options. Text: boolean values are shown as text. White dots are displayed with the `true` values to help you distinguish them from the `false` ones. There are the following options of editing a boolean value that is shown as text: Double-click a cell and select a value from the drop-down list. To toggle the values, select a cell and press `Space`. To set a certain value, select a cell and type the value's first letter: `f` for `false`, `t` for `true`, `d` for `default`, `n` for `null`, `g` for `generated`, and `c` for `computed`. Checkboxes: boolean values are shown as checkboxes. If the checkbox is selected, the value is `true`. If the checkbox is cleared, the value is `false`. To set NULL or DEFAULT values, right-click a cell and select Set NULL or Set DEFAULT.

Option

Description

Use custom font

Set the dedicated font for your data. The font is applied for query results and data editor, not for query consoles and your SQL files.

Alternate row colors

Select this checkbox to make the table row colors alternate between two kinds of colors.

Show boolean values as

Set how you want to display boolean values in the data editor. You can select between the following options.

Text: boolean values are shown as text. White dots are displayed with the true values to help you distinguish them from the false ones.
There are the following options of editing a boolean value that is shown as text:
1. Double-click a cell and select a value from the drop-down list.
2. To toggle the values, select a cell and press Space.
3. To set a certain value, select a cell and type the value's first letter: f for false, t for true, d for default, n for null, g for generated, and c for computed.
Checkboxes: boolean values are shown as checkboxes. If the checkbox is selected, the value is true. If the checkbox is cleared, the value is false.

To set NULL or DEFAULT values, right-click a cell and select Set NULL or Set DEFAULT.

Last modified: 11 February 2024