# DROP TABLE

The `DROP TABLE` command drops the specified table.

## Syntax

```

DROP [TEMPORARY] TABLE [IF EXISTS] <table_name> [FORCE];

```

## Remarks

* `<table_name>` is the name of a table in a SingleStore database.
* This command can be run on the master aggregator node, or a child aggregator node (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.
* If there is a view which depends on a table, the table cannot be dropped. See [CREATE VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-view.md) for more information.
* By default, the `DROP TABLE` command waits for the running queries to finish before dropping the table. To override this behavior and kill any running queries, use the `FORCE` option.
* Table memory can be freed when the `DROP TABLE` command is run.

  For information on when/how much table memory is freed when this command is run, see [Managing Memory](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/maintain-your-cluster/managing-memory.md).
* `DROP TEMPORARY TABLE` does not perform a `COMMIT` when run; issue a `COMMIT` prior to `DROP TEMPORARY TABLE` if there are uncommited statements.
* Because temporary tables only exist for the duration of a client session, no access privileges are required to run `DROP TEMPORARY TABLE`.
* Unlike when running the `DROP TABLE` command, running the `DROP TEMPORARY TABLE` command does not commit implicitly.
* `DROP TEMPORARY TABLE` cannot drop global temporary tables.
* A temporary or global temporary table can be dropped using `DROP TABLE` without specifying the `TEMPORARY` option.
* 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.

## Example

```sql
DROP TABLE IF EXISTS mytbl;

```

```sql
DROP TABLE IF EXISTS tab1 FORCE;

```

***

Modified at: June 11, 2026

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

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