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.
To delete a publication (Sybase Central Admin mode)
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 from the popup menu.
To delete a publication (SQL)
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
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|