DROP RESOURCE POOL
Description
Drops a resource pool.
The resource pool cannot be deleted if it is associated with a role.
Precautions
Only users with the SYSADMIN permission, or the initial user can perform this operation.
This syntax is not supported during upgrade.
Syntax
DROP RESOURCE POOL [ IF EXISTS ] pool_name;
Parameters
- 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 that complies with the Identifier Naming Conventions.
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.
Helpful Links
7.13.6.25-ALTER RESOURCE POOL and 7.13.8.37-CREATE RESOURCE POOL
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
