• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP RESOURCE POOL

DROP RESOURCE POOL

Function

DROP RESOURCE POOL deletes a resource pool.

NOTE:

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 convention.

NOTE:

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

Example

See Example in CREATE RESOURCE POOL.