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 ...

It’s sometimes difficult to know which SQL syntax to use when combining data that spans multiple tables. SQL provides several different statements for performing this type of task; knowing which ...