drop compareset

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

Syntax

drop compareset compareset_name

Parameters

compareset_name – the name of the compareset to be deleted with optional wildcards.

Examples

Example 1 – drops the compareset “cust_orders”:
```
drop compareset cust_orders
go
```
This command also deletes all partition boundary values stored for this compareset.
Example 2 – drops compareset names that end with "s":
```
drop compareset *s
go
```

Parent topic: Compareset Commands

Created June 6, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com