Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

DROP SUBSCRIPTION statement [SQL Remote]

Drops a subscription for a user from a publication.

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

    The name of the publication to which the user is being subscribed. This can include the owner of the publication.

  • subscription-value

    A string that is compared to the subscription expression of the publication. This value is required if and only if the subscription you are dropping contains a subscription value.

  • subscriber-id

    The user ID of the subscriber to the publication.


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.


You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

  • ANSI/ISO SQL Standard

    Not in the standard.


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

FOR Sam_Singer;