Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » Replication Design for SQL Remote » SQL Remote installation design » Publishing data

 

Dropping publications

You can drop a publication using either Sybase Central or the DROP PUBLICATION statement. If you drop a publication, all subscriptions to that publication are automatically deleted as well.

You must have DBA authority to drop a publication.

To delete a publication (Sybase Central)

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

  2. Open the Publications folder.

  3. Right-click the desired publication and choose Delete from the popup menu.

To delete a publication (SQL)

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

  2. Execute a DROP PUBLICATION statement.

Example

The following statement drops the publication named PubOrders.

DROP PUBLICATION PubOrders;

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