The following is a general description on how to edit table data using the variable substitution feature in DbVisualizer:
- Select a table in the Databases tab and open its Data tab in
- Right-click in the Data tab grid and open the Script to SQL Commander sub menu
|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.