Edit

DROP WORKLOAD CLASSIFIER (Transact-SQL)

  • Article

Applies to: Azure Synapse Analytics

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.

Transact-SQL syntax conventions

Syntax

DROP WORKLOAD CLASSIFIER classifier_name;

Note

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

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)
Azure Synapse Analytics Workload Classification