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 Data Table Viewer can used to help quickly generate the SQL for for these scripts.
View Generated Sql for Inserts
Click on the Insert button from Table Data Viewer.
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 Table Data Viewer.
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 operation can be copied from SQL Preview tab into a SQL script.
Update and Delete SQL Preview
See also: