drop database

Drop a database

Syntax

drop_database:
          DROP {DATABASE | SCHEMA} [IF EXISTS] {database_name | db-uri}

Description

The DROP DATABASE statement deletes both the definition and the content of the database named database_name or identified by the db-uri. An error will be returned if the database does not exist unless the IF EXISTS option is specified.

Note that this statement is not transactional—the database is irrevocably deleted when this statement is executed. A ROLLBACK is not possible.