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.

Syntax

DROP PUBLICATION [ owner.]publication-name

owner, publication-name : identifier

Remarks

This statement is applicable only to MobiLink and SQL Remote.

Permissions

Must have DBA authority.

Side effects

Automatic commit. All subscriptions to the publication are dropped.

See also

• 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

Standards and compatibility

Example

The following statement drops the pub_contact publication.

DROP PUBLICATION pub_contact;