Destroying a Database

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