User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To drop a subscription for a user from a publication.

Syntax

     DROP SUBSCRIPTION TO publication-name [ ( string ) ]
          ...     FOR userid,...

Usage

Anywhere. This statement is applicable only to SQL Remote.

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