In the case above, 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 ...

[Click on image for larger view.] Figure 1. The main application form. The Table Counts button generates an alphabetical list of all tables by schema and table name, along with the current count of ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.