When you drop a publication, all subscriptions to that publication are automatically deleted.
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.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, expand the Publications folder.
Right-click the desired publication and choose Delete.
Connect to the database as a user with DBA authority.
Execute a DROP PUBLICATION statement.
For example, the following statement drops the publication named PubOrders.
DROP PUBLICATION PubOrders;
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|