Question: How do i delete all the tables in the schema on Apache Derby DB using JDBC?

Answer: 
I think most db providers don't allow DROP TABLE \* (or similar).

I think the best way would be to SHOW TABLES and then go through each deleting in a loop via a resultset.

HTH.
If you're working from the command prompt rather than through JDBC, this should get you started.

```
SELECT 'DROP TABLE ' || schemaname ||'.' || tablename || ';'
FROM SYS.SYSTABLES
INNER JOIN SYS.SYSSCHEMAS ON SYS.SYSTABLES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID
;

```