DROP DATABASE

This page documents the preview version (v2.21). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

Synopsis

Use the DROP DATABASE statement to remove a database and all of its associated objects from the system. This is an irreversible statement. A currently-open connection to the database will be invalidated and then closed as soon as the statement is executed using that connection.

Syntax

drop_database ::= DROP DATABASE [ IF EXISTS ] database_name

drop_database

DROPDATABASEIFEXISTSdatabase_name

Semantics

drop_database

DROP DATABASE [ IF EXISTS ] database_name

Remove a database and all associated objects. All objects that are associated with database_name such as tables will be invalidated after the drop statement is completed. All connections to the dropped database would be invalidated and eventually disconnected.

database_name

Specify the name of the database.

See also