If you are the database administrator for the database mydb, you can destroy it using the following Unix command:
% dropdb 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