Dropping a Database

Go Up to Creating Databases (Data Definition Guide)

DROP DATABASE is the command that deletes the database currently connected to, including any associated shadow and log files. Dropping a database deletes any data it contains. A database can be dropped by its creator, the ­SYSDBA user, and any users with operating system root privileges.

The following statement deletes the current database:

DROP DATABASE;