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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

DROP SUBSCRIPTION statement [SQL Remote] Next Page

DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]


Use this statement to drop a synchronization subscription in a MobiLink remote database.

Syntax

DROP SYNCHRONIZATION SUBSCRIPTION
TO publication-name
[ FOR ml_username, ... ]

Parameters

TO clause    Specify the name of a publication.

FOR clause    Specify one more MobiLink users.

Omitting this clause drops the default settings for the publication.

Permissions

Must have DBA authority. Requires exclusive access to all tables referred to in the publication.

Side Effects

Automatic commit.

See also
Standards and compatibility
Examples

The following example drops the subscription between the MobiLink user ml_user1 and the publication called sales_publication:

DROP SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR "ml_user1";

The following example omits the FOR clause, and so drops the default settings for the publication called sales_publication:

DROP SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication;