DROP SUBSCRIPTION TO publication-name [ ( subscription-value ) ]
 FOR subscriber-id, ...

subscription-value : string

subscriber-id : string

Drops a SQL Remote subscription for a user ID to a publication in the current database. The user ID will no longer receive updates when data in the publication is changed.

In SQL Remote, publications and subscriptions are two-way relationships. If you drop a subscription for a remote user to a publication on a consolidated database, you should also drop the subscription for the consolidated database on the remote database to prevent updates on the remote database being sent to the consolidated database.

DBA authority.

Automatic commit.

• CREATE SUBSCRIPTION statement [SQL Remote]
• STOP SUBSCRIPTION statement [SQL Remote]
• ISYSSUBSCRIPTION system table

The following statement drops a subscription for the SamS user ID to the pub_contact publication.

DROP SUBSCRIPTION TO pub_contact
FOR SamS;