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

Syntax

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

Parameters

Permissions

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

Side Effects

Automatic commit.

See also

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

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;