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.

Must have DBA authority, or be the owner of the publication. Requires exclusive access to all tables referred to in the statement.

Automatic commit. All subscriptions to the publication are dropped.

• ALTER PUBLICATION statement [MobiLink] [SQL Remote]
• CREATE PUBLICATION statement [MobiLink] [SQL Remote]
• SQL Anywhere MobiLink clients: Publishing data
• UltraLite MobiLink clients: DROP PUBLICATION statement [UltraLite] [UltraLiteJ]
• Dropping publications

The following statement drops the pub_contact publication.

DROP PUBLICATION pub_contact;