Drop a publication

When you drop a publication, all subscriptions to that publication are automatically deleted.

Caution

Dropping publications in a running SQL Remote system can cause replication errors and a loss of data in the replication system. See Upgrading and resynchronization.

To delete a publication (Sybase Central)

  1. Connect to the database as a user with DBA authority.

  2. In the left pane, expand the Publications folder.

  3. Right-click the desired publication and choose Delete.

To delete a publication (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a DROP PUBLICATION statement.

    For example, the following statement drops the publication named PubOrders.

    DROP PUBLICATION PubOrders;

    See DROP PUBLICATION statement [MobiLink] [SQL Remote].

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1