DROP RESOURCE POOL ​

Function ​

DROP RESOURCE POOL deletes a resource pool.

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 a specified resource pool does not exist.

• pool_name

  Specifies the name of a created resource pool.

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

Examples ​

See Examples in CREATE RESOURCE POOL.

Helpful Links ​

ALTER RESOURCE POOL and CREATE RESOURCE POOL