User's 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.
See also “DROP SUBSCRIPTION statement [SQL Remote]” [ASA SQL Reference,
page 465]
“CREATE SUBSCRIPTION statement” on page 358
“DROP SUBSCRIPTION statement” on page 363
363