View Generated Sql
In some cases it may be undesirable to modify database data using a GUI because the modifications aren't repeatable. In these cases it may be better to use a SQL script to perform data modifications. DbWrench's table data viewer can used to help quickly generate the SQL for for these scripts.
View Generated Sql for Inserts
Click on the Insert button from Data tab.
A form will be dynamically generated for this table. Fill in the values for this table.
The SQL text can be copied from SQL Preview tab into a SQL script.
View Generated Sql for Update and Deletes
Click on the Update button from Data tab.
A form will be dynamically generated for this table. Fill in the values for this table.
The SQL text for either the Update or Delete command can be copied from SQL Preview tab.
Update and Delete SQL Preview
See also: