Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 17. Command Reference for Adaptive Server Anywhere       

DROP SUBSCRIPTION statement

Function 

To drop a subscription for a user from a publication.

Syntax 

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

Parameters 

Parameter	Description
publication-name	The name of the publication to which the user is being subscribed. This may include the owner of the publication.
subscription-value	A string that is compared to the subscription expression of the publication. This value is required because a user may have more than one subscription to a publication.
subscriber-id	The user ID of the subscriber to the publication.

Permissions 

Must have DBA authority.

Side effects 

Automatic commit.

See also 

CREATE SUBSCRIPTION statement

Description 

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.

Example 

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

DROP SUBSCRIPTION TO pub_contact
FOR SamS