If you are the database administrator for the database mydb, you can destroy it using the following UNIX command:
% destroydb dbname
This action physically removes all of the UNIX files
associated with the database and cannot be undone, so this should
only be done with a great deal of forethought.
It is also possible to destroy a database from within an SQL session by using
> drop database dbname