CODEWITHSUNDEEP
javadatabasehsqldb
Dan
Dan

Reputation: 9791

How do you delete the default database/schema in hsqldb

I've created an in memory hsqldb and am using the default database/schema. Now I want to drop and recreate the database programatically.

How do I do that?

Upvotes: 4

Views: 7036

Answers (1)

fredt
fredt

Reputation: 24352

DROP SCHEMA PUBLIC CASCADE

This will purge the public schema. If you create other schemas, use the same command with the schema name instead of PUBLIC.

Upvotes: 13

Related Questions