Databases are destroyed with the command DROP DATABASE:

      DROP DATABASE name;
      

Only the owner of the database, or a superuser, can drop a database. Dropping a database removes all objects that were contained within the database. The destruction of a database cannot be undone.