# DROP RESULT TABLE

The `DROP RESULT TABLE` command drops the specified result table.

A result table is used only to [read query results in parallel](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/read-query-results-in-parallel.md). To drop any table besides a result table, use the [DROP TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-table.md) command.

## Syntax

```
DROP RESULT TABLE <result_table_name>;

```

## Remarks

* 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 does not wait for any running queries against the result table to finish before dropping the table. This is because it is assumed that each reader that is reading the result table has completed its read before `DROP RESULT TABLE` is run. For more information, see [Read Query Results in Parallel](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/read-query-results-in-parallel.md).

## Example

```sql
DROP RESULT TABLE my_result_tbl;

```

***

Modified at: June 11, 2026

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

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