If your ultimate goal it to start over with a new schema; an option is to rename/delete the directory within which the db exists.
IF EXISTS is a non-std extension AFAICT. You can do this portably byBrad Berens < firstname.lastname@example.org> writes:
> I've googled for this but all I can find is create statements so I'm hoping
> someone can just give me a quick answer. I'm trying to write some db
> creation scripts. Normally in MSSQL I would use an if exists from the
> system tables to check whether or not to run a drop before creating the
> table. I found the sys.systables info about derby, but I can't seem to get
> the if clause working for that.
> IF EXISTS (SELECT * FROM sys.systables WHERE tablename='[tablename]') DROP
> TABLE [tablename];
using DatabaseMetaData.getTables(...). It is a bit more work so you might
want to wrap it in a java method.