Skip to content
The latest version of DbVisualizer was released 2025-09-19DOWNLOAD HERE ->

Editing a Result Set

Only in DbVisualizer Pro

This feature is only available in the DbVisualizer Pro edition.

A result set from a query that fulfills these requirements is editable:

  1. The SQL is a query command,
  2. Only one table is referenced in the FROM clause,
  3. All current columns exist by name (case-sensitive) in the identified table.

If the result set is not editable, a Read-only message will be displayed in the grid status bar. To show why, hover the mouse over the message or click it to see the details.

For performance reasons, metadata such as column information is saved in a local cache. If there is a mismatch between the local cache and the column metadata in the result set, the grid is read-only with an icon in front of the Read-only message.

Clicking the icon will display a dialog with the details of the mismatch and options to compare what columns differ and to refresh the local cache.

The diff window shows what columns don't match:

If you want results to always be read-only, you can enable the Make Result Sets Read-Only setting in the Tool Properties dialog, in the SQL Commander/Result Sets category under the General tab.

A result set like this can be edited in the same way as you can edit table data.