Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » MobiLink - Client Administration » SQL Anywhere Clients » Publishing data

Altering existing publications Next Page

Dropping publications

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 the desired publications and choose Delete from the popup menu.

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].

    3. Example

    The following statement drops the publication named pub_orders.

    DROP PUBLICATION pub_orders