The Delete Data Generator generates Delete SQL statements. The generated statements can be executed directly on your target database to erase the data, or saved to file to be executed later on a database and platform of your choice.
When used with the Test Data Generator, you can easily load and unload sets of test data to perform and repeat unit and system testing.
The following shows example Delete SQL statements for a Microsoft Jet database:
delete from [Order Line]
where [fk customer] = 100
delete from [Order]
where [fk customer] = 100
delete from [Customer]
where [Id1] = 100
Figure 0.1 Example Delete SQL statements generated by TurboData
See TurboData Scenarios Overview