FirebirdSQL logo
 Data Definition (DDL) StatementsSHADOW 

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:

Example of DROP DATABASE

Deleting the current database
DROP DATABASE;
See also

[fblangref50-ddl-db-create], [fblangref50-ddl-db-alter]