drop-workload-classifier-transact-sql.md

title	DROP WORKLOAD Classifier (Transact-SQL)
description	DROP WORKLOAD Classifier (Transact-SQL)
author	WilliamDAssafMSFT
ms.author	wiassaf
ms.reviewer	wiassaf
ms.date	11/04/2019
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
f1_keywords	WORKLOAD CLASSIFIER WORKLOAD_CLASSIFIER_TSQL DROP_WORKLOAD_CLASSIFIER_TSQL DROP WORKLOAD GROUP
helpviewer_keywords	DROP WORKLOAD CLASSIFIER statement
dev_langs	TSQL
monikerRange	=azure-sqldw-latest

DROP WORKLOAD CLASSIFIER (Transact-SQL)

[!INCLUDE asa]

Drops an existing user-defined workload management classifier. If requests are running or in the request queue in suspended state, they will keep their classification and the classifier can be dropped immediately. Dropping and recreating the classifier with different importance will not affect an already classified request.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DROP WORKLOAD CLASSIFIER classifier_name;

Note

[!INCLUDEsynapse-analytics-od-unsupported-syntax]

Arguments

classifier_name
Specifies the name by which the workload classifier is identified.

Permissions

Requires CONTROL DATABASE permission.

Examples

The following example drops the workload classifier named wgcELTROLE.

DROP WORKLOAD CLASSIFIER wgcELTRole;

Note

A request submitted without a matching classifier, is classified to the default workload group. The default workload group is the smallrc resource class.

See Also

CREATE WORKLOAD CLASSIFIER (Transact-SQL)
[[!INCLUDEssazuresynapse-md] Workload Classification](/azure/sql-data-warehouse/sql-data-warehouse-workload-classification)