Drop a database

If you are logged in as the admin user or the owner of a database, you can drop the database by using the DROP DATABASE command.

Dropping the database removes the entries for an existing database and deletes the directory that contains the data. For example:

MYDB.SCHEMA(USER)=> DROP DATABASE mydb;
DROP DATABASE