I resorted to using DELETE FROM statements for each table, and suffered the performance penalty. What I would have preferred is the ability to run a SQL script to delete all the data from the database ...

I have a value that I want to do delete everything from a table that contains this value in a field. Also, each one of those that I delete has an ID that is a foreign key value in another table.