Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 17. Command Reference for Adaptive Server Anywhere       

DROP PUBLICATION statement

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