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

DROP PUBLICATION statement [MobiLink] [SQL Remote]

Use this statement to drop a publication. 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.

DROP PUBLICATION [ owner.]publication-name

owner, publication-name : identifier

This statement is applicable only to MobiLink and SQL Remote.

Must have DBA authority.

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: UltraLite DROP PUBLICATION statement

• SQL/2003    Vendor extension.

The following statement drops the pub_contact publication.

DROP PUBLICATION pub_contact;