drop thread pool

Drops a user-defined pool.

Considerations for process mode

drop thread pool is not supported in process mode.

drop thread pool pool_name
	[for instance inst_name | global ]

pool_name – name of the pool you are dropping.
for instance [inst_name | global] – is name of the instance, or global for all instances.

Example 1 – Drops a pool named sales_pool:
```
drop thread pool sales_pool
```

The SAP ASE server reassigns tasks associated with the dropped thread pool to syb_default_pool.
You cannot drop thread pools that are currently using an execution class definition. Use sp_dropexeclass to remove the execution class.
You cannot drop system-created thread pools (those beginning with syb_).
Thread pools must wait for currently running tasks to yield before they can be dropped, which may cause a slight delay in the SAP ASE server dropping the pool.
Tasks running in a thread pool that you drop migrate to syb_default_pool.
You cannot use Transact-SQL variables as parameters to drop thread pool.
You can issue drop thread pool with execute immediate.

ANSI SQL-Compliance level: Transact-SQL extension

The permission checks for drop thread pool differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage any thread pool` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role.