ASA SQL Reference

SQL Statements

DROP PUBLICATION statement

Description 

Use this statement to drop a publication. In MobiLink a publication identifies synchronized data in a Adaptive Server 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

Usage 

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
• CREATE PUBLICATION statement
• sp_drop_publication procedure

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

Example 

The following statement drops the pub_contact publication.

DROP PUBLICATION pub_contact

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.