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:
- The SQL is a SELECT command,
- Only one table is referenced in the FROM clause,
- All current columns exist by name (case sensitive) in the identified table.
A result set like this can be edited in the same way as you can edit table data.
If all of the above requirements are fulfilled but the edit controls are still not shown, please try qualifying the table name with the schema and/or database name.
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.