SingleStore DB

DROP DATABASE

Drops a 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 database.

  • 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 when DDL Forwarding is enabled. See Node Requirements for SingleStore DB Commands).

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