Help Center> GaussDB> Distributed_2.x> SQL Reference> SQL Syntax> DROP RESOURCE POOL
Updated on 2023-10-23 GMT+08:00
View PDF

DROP RESOURCE POOL

The current feature is a lab feature. Contact Huawei technical support before using it.

Function

DROP RESOURCE POOL deletes a resource pool.

The resource pool cannot be deleted if it is associated with a role.

Precautions

Only a user with the DROP permission on the current database can perform this operation.

Syntax

DROP RESOURCE POOL [ IF EXISTS ] pool_name;

Parameter Description

  • IF EXISTS

    Reports a notice instead of an error if the specified resource pool does not exist.

  • pool_name

    Specifies the name of the resource pool to be deleted.

    Value range: a string. It must comply with the naming convention.

In a multi-tenant scenario, deleting a group resource pool also deletes the related service resource pools. A resource pool can be deleted only when it is not associated with any users.

Examples

See Examples in CREATE RESOURCE POOL.

Helpful Links

ALTER RESOURCE POOL and CREATE RESOURCE POOL

Parent topic: SQL Syntax