Contents Index DROP REMOTE MESSAGE TYPE statement GRANT CONSOLIDATE statement

SQL Remote User's Guide
  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-valuestring

subscriber-idstring

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 

DROP SUBSCRIPTION statement [SQL Remote]

CREATE SUBSCRIPTION statement

DROP SUBSCRIPTION statement


Contents Index DROP REMOTE MESSAGE TYPE statement GRANT CONSOLIDATE statement