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 PUBLICATION statement [MobiLink] [SQL Remote]

Drops a publication.

DROP PUBLICATION [ IF EXISTS ] [ owner.]publication-name
owner, publication-name : identifier

This statement is applicable only to MobiLink and SQL Remote.

In MobiLink, a publication identifies synchronized data in a SQL Anywhere remote database. In SQL Remote, publications identify replicated data in both consolidated and remote databases.

Use the IF EXISTS clause if you do not want an error returned when the DROP PUBLICATION statement attempts to remove a publication that does not exist.

DROP PUBLICATION requires exclusive access to all tables referred to in the publication.


You must be the owner of the publication, or have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit. All subscriptions to the publication are dropped.

  • ANSI/ISO SQL Standard

    Not in the standard.


The following statement drops the pub_contact publication.