Sybase SQL Remote DC38133-01-0902-01 User 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
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.
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.
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
how SQL Remote replicates procedures and triggers, see
101