Sybase SQL Remote DC38133-01-0902-01 User Manual

Chapter 17. Command Reference for Adaptive Server Anywhere

DROP SUBSCRIPTION statement

Function

Use this statement to drop a subscription for a user from a publication.

Syntax

DROP SUBSCRIPTION TO publication-name [ ( subscription-value ) ]

FOR subscriber-id , . . .

subscription-value: string

subscriber-id : string

Parameters

Parameter

Description

publication-name

The name of the publication to which the user is be-
ing 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.