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

Answer: 
Do a little method in java in which you execute a 

```
DROP TABLE [tablename]

```

`tablename` is passed by parameter.

And another method in which you loop over a record set formed by the query

```
SELECT tablename FROM SYSTABLES

```

calling the first method.

[Derby latest documentation](http://db.apache.org/derby/docs/10.4/ref/)
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.