ASA SQL Reference

SQL Statements

DROP SYNCHRONIZATION USER statement [MobiLink]

Description 

Use this statement to drop a synchronization user from a MobiLink remote database.

Syntax 

DROP SYNCHRONIZATION USER ml_username, ...

ml_username: identifier

Usage 

Drop one or more synchronization users from a MobiLink remote database.

Permissions 

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

Side Effects 

All subscriptions associated with the user are also deleted.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

Example 

Remove MobiLink user ml_user1 from the database.

DROP SYNCHRONIZATION USER ml_user1

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.