DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Drops a synchronization subscription in a remote database.

Syntax

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

Parameters

subscription-name
Specifies the name of the subscription to drop.
TO clause
Specifies the name of a publication.
FOR clause
Specifies one more users.

Omitting this clause drops the default settings for the publication.

Remarks

Requires exclusive access to all tables referred to in the publication.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards

Example

The following example drops the subscription named sales:

DROP SYNCHRONIZATION SUBSCRIPTION sales;

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

DROP SYNCHRONIZATION SUBSCRIPTION
   TO user.sales_publication
   FOR "SSinger";

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

DROP SYNCHRONIZATION SUBSCRIPTION
   TO user.sales_publication;