iQSonar v4 - Brendan R1 contains a stored procedure, model.DeleteScanData, which can be used to delete all scan data from an iQSonar scan engine database.
What's Affected?
All tables in the dbo schema and most tables in the config schema will remain untouched. Two exceptions are the config.t_DynamicTarget and config.t_DynamicTarget_Project tables, both of which will be cleared down.
Outside of the dbo and config schemas the model.t_Product and model.hibernate_unique_key tables will remain unchanged. All other tables will be cleared down.
Usage
exec model.DeleteScanData