Sybase DC38133-01-0902-01 To delete a publication Sybase Central, To delete a publication SQL

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