Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

DROP SYNCHRONIZATION USER statement [MobiLink]

Drops one or more synchronization users from a SQL Anywhere remote database.

Syntax
DROP SYNCHRONIZATION USER ml-username, ...
ml-username : identifier
Remarks

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

You must have exclusive access to all tables referred to by publications subscribed to by the user.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

All subscriptions associated with the user are also deleted.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

Example

Remove MobiLink user SSinger from the database.

DROP SYNCHRONIZATION USER SSinger;