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)

1. Connect to the remote database as a user with DBA authority using the SQL Anywhere plug-in.

2. Open the Publications folder.

3. Right-click a publication and choose Delete.

To delete a publication (SQL)

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

2. Execute a DROP PUBLICATION statement.

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

Example

The following statement drops the publication named pub_orders.

DROP PUBLICATION pub_orders