Help Center > > Developer Guide> SQL Reference> SQL Syntax> DROP RESOURCE POOL

DROP RESOURCE POOL

Updated at: Mar 13, 2020 GMT+08:00

Function

DROP RESOURCE POOL deletes a resource pool.

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

Precautions

The user must have the DROP permission in order to delete a resource pool.

Syntax

DROP RESOURCE POOL [ IF EXISTS ] pool_name;

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the stored procedure does not exist.

  • pool_name

    Specifies the name of a created resource pool.

    Value range: A string compliant with the identifier naming rules.

A resource pool can be independently deleted only when it is not associated with any users.

Examples

See Examples in CREATE RESOURCE POOL.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel