Figure 0.2 Edit Delete Data Scenario
This is the dialog used to select the desired tables for delete data generation.
The available database tables for this scenario are shown on the left, and the tables selected for delete data generation are on the right.
Select the tables that you want to generate Delete SQL statements for by dragging and dropping the tables from the 'Available Tables' tree. To enter a Where clause to restrict the data to be deleted, select the table on the right hand tree and either type in the text or build it with the SQL Builder .
You can set a default Where clause for a table by selecting a table from the left side 'Available Tables' tree and updating it. Then each time that table is selected for any delete data scenario, it will initially use the default until it is overridden.
Move the order of the tables by selecting a table with the mouse and dragging it vertically up or down.
Helpful Hint: To first see which rows of data will be affected by the generated Delete SQL statement, copy and paste your Where Clause on to the same table in the Select SQL generator, run it, and examine the results file to see which rows will be deleted.
