Outdated Version

You are viewing an older version of this section. View current production version.

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;