User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To drop a SQL Remote publication.

Syntax

     DROP PUBLICATION [ owner.]publication-name

Usage

Anywhere. This statement is applicable only to SQL Remote.

Permissions

Must have DBA authority.

Side effects

Automatic commit. All subscriptions to the publication are dropped.

See also

• CREATE PUBLICATION statement

Description

The DROP PUBLICATION statement drops an existing publication from the database.

Publication definitions are held at both consolidated and remote databases in a SQL Remote installation.

Example

     DROP PUBLICATION pub_contact