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?

Tutorial: [Deleting a File or Directory](https://docs.oracle.com/javase/tutorial/essential/io/delete.html) — Gord Thompson, Sep 04 '16 at 12:10
By the way, if you need a temporary database without persistence, H2 supports “in-memory” mode where the database lives only in memory, never gets written to storage, and disappears when your app exits. — Basil Bourque, Aug 12 '18 at 15:40

score 8 · Answer 1 · edited May 23 '17 at 12:00

8

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);

edited May 23 '17 at 12:00

Community

answered Mar 14 '17 at 09:24

cdr89

this does not work, try creating table then call this method and again try to create the table with the same name, it will still throw an error as the table is already exists – nomadSK25 Apr 21 '20 at 18:58

score 1 · Answer 2 · answered Aug 12 '18 at 14:39

1

Statement s = connection.createStatement();
s.execute("drop all objects delete files");

answered Aug 12 '18 at 14:39

user939857

2 Answers2