# DROP DATABASE

The `DROP DATABASE` command drops a database.

> **📝 Note**: This command does not drop [remote storage databases](https://docs.singlestore.com/db/v9.1/manage-data/local-and-unlimited-database-storage-concepts.md). To do that, use [DETACH DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/detach-database.md).

## Syntax

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

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



```

## Arguments

* `<database_name>`: The name of a SingleStore [local storage database](https://docs.singlestore.com/db/v9.1/manage-data/local-and-unlimited-database-storage-concepts.md).

## Remarks

* 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.
* The `DROP DATABASE` command can be run on the master aggregator node, or a child aggregator node when DDL Forwarding is enabled. See [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* The `DROP DATABASE` command cannot be run on [system databases](https://docs.singlestore.com/db/v9.1/reference/system-databases.md).
* The `DROP DATABASE` command drops the Point-In-Time Recovery (PITR) history. A database cannot be restored to the PITR milestone taken before the database was dropped.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Examples

```sql
DROP DATABASE IF EXISTS test;

```

```sql
DROP DATABASE IF EXISTS db FORCE;

```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-database/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-database/)

(An index of the documentation is available at /llms.txt)