How to delete a H2 database file programmatically?

Question

I'm developing an application using JDBC and an H2 database, and occasionally there is a need to delete the database file. Is there a way to do that?

Answer 1

Yes, you can!

Refer to this answer to locate the folder where H2 stores the database (usually user's home directory): Where does H2's Embedded Databases Store the data?

To delete it, you can use the org.h2.tools.DeleteDbFiles class as follows:

DeleteDbFiles.execute(dbDir, dbName, true);

More info about DeleteDbFiles class: http://www.h2database.com/javadoc/org/h2/tools/DeleteDbFiles.html