DROP DATABASE

`DROP DATABASE`

Drops (deletes) the database of the current connection

Available in

DSQL, ESQL

Syntax

DROP DATABASE

The DROP DATABASE statement deletes the current database.Before deleting a database, you have to connect to it.The statement deletes the primary file, all secondary files and all shadow files.

Note	Contrary to `CREATE DATABASE` and `ALTER DATABASE`, `DROP SCHEMA` is not a valid alias for `DROP DATABASE`.This is intentional.

Who Can Drop a Database

The DROP DATABASE statement can be executed by:

Administrators
Users with the DROP DATABASE privilege