The following is a general description on how to edit table data using the variable substitution feature in DbVisualizer:

  1. Select a table in the Databases tab and open its Data tab in
  2. Right-click in the Data tab grid and open the Script to SQL Commander sub menu
The sub menu contains the following operations (all of them expect SELECT ALL requires at least one selected cell in the grid):


SELECT ALL Generates a plain SELECT * FROM <table> statement
SELECT ALL WHERE Generates a SELECT * FROM <table> WHERE <selected-columns>
SELECT ALL WITH FILTER Produces a SELECT * FROM <table> WHERE <current-filter>
INSERT INTO TABLE Generates an INSERT INTO statement with no values
INSERT COPY INTO TABLE Generates a INSERT statement with the same data as in the selected row
UPDATE WHERE Produces an UPDATE statement and prompts what columns should be included in the WHERE clause
DELETE WHERE Produces a DELETE statement and prompts what columns should be included in the WHERE clause

Choosing any of these operations will create a SQL statement and open in a new SQL Editor. Depending on the setting of Include Variables in SQL in Tools->Tool Properties and the General / Table Data category, the statement will either contains literals or DbVisualizer variables. DbVisualizer will prompt for values if SQLs executed in the SQL Commander contains variables.


DbVisualizer Pro includes a fully featured spreadsheet editing feature.