How do you delete the default database/schema in hsqldb

Question

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?

Thanks Daniel

Answer 1

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.