DROP RESOURCE POOL

DROP RESOURCE POOL deletes a resource pool.

If a role has been associated with a resource pool, the resource pool cannot be deleted.

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

 DROP RESOURCE POOL [ IF EXISTS ] pool_name;
 

**Table 1** DROP RESOURCE POOL parameters
Parameter	Description	Value Range
IF EXISTS	Sends a notice instead of an error if the specified resource pool does not exist.	-
pool_name	Specifies the name of a created resource pool.	A string, which must comply with the naming convention.

Delete resource pool pool.

 DROP RESOURCE POOL pool;
 

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.