# DROP RESOURCE POOL

The `DROP RESOURCE POOL` command drops the specified resource pool.

## Syntax

```sql
DROP RESOURCE POOL pool_name

```

## Remarks

* `pool_name`: The name of a resource pool.
* `DROP POOL` privileges are required for dropping a resource pool.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

> **⚠️ Warning**: Open connections to a database are assigned to a specific resource pool (or `default_pool` if no other pool is selected). Before dropping a resource pool, you should set `resource_pool` to another value; otherwise only [DDL commands](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl.md) can be run from those connections until a new `resource_pool` value has been set.

You cannot drop the [built-in resource pools](https://docs.singlestore.com/cloud/user-and-workspace-administration/use-the-workload-manager-and-set-resource-limits/set-resource-limits/resource-pool-basics/#section-idm4510351909488033483313104461.md). You also cannot drop a pool that is the [default startup pool](https://docs.singlestore.com/cloud/user-and-workspace-administration/use-the-workload-manager-and-set-resource-limits/set-resource-limits/administer-default-resource-pools/#section-idm4636389618025633489880406952.md) for a user.

## Example

This example assumes that the resource pool `test_pool` exists and that you want to drop it.

Before dropping `test_pool`, set the current resource pool to a value other than `test_pool`:

```sql

SET resource_pool = default_pool;

```

Then drop the `test_pool`:

```sql

DROP RESOURCE POOL test_pool;

```

***

Modified at: June 11, 2026

Source: [/cloud/reference/sql-reference/resource-pool-commands/drop-resource-pool/](https://docs.singlestore.com/cloud/reference/sql-reference/resource-pool-commands/drop-resource-pool/)

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