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
  • SQL/2003   Vendor extension.

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;