drop=true attribute

Function

Removes the in-memory database specified within the database connection URL. Generates the SQLException 08006 if successful. If the database does not exist, generates an error reporting that the database could not be found.

It is not necessary to shut down the database before dropping it.

If you specify this attribute with a database that is not an in-memory database, Derby generates the SQLException XBM0I.

Combining with other attributes

This attribute, like shutdown=true, cannot be combined with other attributes.

Examples

-- drop an in-memory database using the embedded driver
jdbc:derby:memory:myInMemDB;drop=true
-- drop an in-memory database using the Network Server
jdbc:derby://localhost:1527/memory:myInMemDB;drop=true