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] db_name [FORCE]

DROP SCHEMA [IF EXISTS] db_name [FORCE]

Remarks

  • db_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.

Example

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