AttentionThis page documents an earlier version. Go to the latest (v2.3) version.
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.
drop_database ::= DROP DATABASE [ IF EXISTS ] database_name
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.
Specify the name of the database.