DROP DATABASE

DROP DATABASE can be used to remove a database and all of its objects.

Permissions

The role must have the DDL permission at the database level.

Syntax

DROP DATABASE database_name

database_name ::= identifier

Parameters

Parameter

Description

database_name

The name of the database to drop. This can not be the current database in use.

Examples

Dropping a database and all of its objects:

DROP DATABASE raviga;