Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> DROP RESOURCE POOL
View PDF

DROP RESOURCE POOL

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.

Helpful Links

ALTER RESOURCE POOL, CREATE RESOURCE POOL

Parent topic: DDL Syntax