Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

DROP DATABASE

Drop the specified database.

Syntax

DROP DATABASE [IF EXISTS] <database_name> [FORCE]

DROP SCHEMA [IF EXISTS] <database_name> [FORCE]

Remarks

  • <database_name> is the name of a SingleStore DB database.
  • This command must be run on the master aggregator node (see Node Requirements for SingleStore DB Commands).
  • By default, the DROP DATABASE command waits for the running queries to finish before dropping the database. To override this behavior and kill any running queries, use the FORCE option.
  • This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore DB Commands ).

Example

DROP DATABASE IF EXISTS test;
DROP DATABASE IF EXISTS db FORCE;