drop compareset

Deletes an existing compareset. drop command fails if the compareset is being used in an existing job.

Syntax

drop compareset compareset_name

Example 1 – drops the compareset “cust_orders”:

drop compareset cust_orders
go

The returned result is:

Compareset “cust_orders” was dropped successfully