DROP SYNCHRONIZATION SUBSCRIPTION {subscription-name |
TO publication-name
[ FOR ml-username, ... ]}

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

Automatic commit.

• ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
• CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
• ISYSSYNC system table
• Dropping MobiLink subscriptions

The following example drops the subscription named mysub:

DROP SYNCHRONIZATION SUBSCRIPTION mysub;

The following example drops the subscription between the 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;