User's Manual

Chapter 7. SQL Remote Design for Adaptive Server Anywhere
❖ 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 pub_orders.
DROP PUBLICATION pub_orders
☞ See also the “DROP PUBLICATION statement” [ASA SQL Reference,
page 459].
Notes on publications
♦ The different publication types described above can be combined. A
single publication can publish a subset of columns from a set of tables
and use a WHERE clause to select a set of rows to be replicated.
♦ DBA authority is required to create and drop publications.
♦ Publications can be altered only by the DBA or the publication’s owner.
♦ Altering publications in a running SQL Remote setup is likely to cause
replication errors and can lead to loss of data in the replication system
unless carried out with care.
♦ Views cannot be included in publications.
♦ Stored procedures cannot be included in publications. For a discussion of
how SQL Remote replicates procedures and triggers, see “Replication of
procedures” on page 80.
101