Dropping a publication for UltraLite

You can drop a publication using either Sybase Central or Interactive SQL.

Sybase Central

In Sybase Central, you can perform this task while working with the connected database.

To drop a publication (Sybase Central)

  1. Connect to the UltraLite database.

  2. In the left pane, double-click the Publications folder.

  3. Right-click the publication and choose Delete.

  4. Click Yes.

Interactive SQL

In Interactive SQL, deleting a publication is also called dropping it. You can perform this task with the DROP PUBLICATION statement.

To drop a publication (Interactive SQL)

  1. Connect to the UltraLite database.

  2. Execute a DROP PUBLICATION statement.

    For example, the following statement drops the publication named pub_orders:

    DROP PUBLICATION pub_orders;
See also
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0