Use the DROP SUBSCRIPTION SET command to drop
an existing subscription set for a specified Apply qualifier.
Syntax
>>-DROP SUBSCRIPTION SET--SETNAME--setname---------------------->
>--APPLYQUAL--applyqual----------------------------------------><
Parameters
- SETNAME setname
- Specifies the subscription-set name.
- APPLYQUAL applyqual
- Specifies the Apply qualifier for the subscription set.
Usage notes
- If the subscription set has members, all members and statements will be
dropped.
- See the DROP MEMBER command for
the rules that affect the dropped objects.
Example
To drop the subscription set SET00:
DROP SUBSCRIPTION SET SETNAME SET00 APPLYQUAL AQ00
SQL Replication