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