You can drop a publication using either Sybase Central or the DROP PUBLICATION statement. Before dropping the publication, you must drop all subscriptions connected to it.
You must have DBA authority to drop a publication.
Connect to the remote database as a user with DBA authority using the SQL Anywhere plug-in.
Open the Publications folder.
Right-click a publication and choose Delete.
Connect to the remote database as a user with DBA authority.
Execute a DROP PUBLICATION statement.
The following statement drops the publication named pub_orders.
DROP PUBLICATION pub_orders
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|