♦Choosea table and click Next.
♦Choosethe columns for the article. ClickNext.
♦Entera WHERE clause (if desired). ClickNext.
♦Createa SUBSCRIBE BY restriction (if desired).
6. Click Finish to create the article.
❖Toremove articles (Sybase Central)
1. Connect to the database as a user who owns the publication or as a user
withDBA authority.
2. Open the Publications folder.
3. Select the publication you want to remove an article from.
4. Right-click the article you want to delete and choose Delete from the
popupmenu.
❖Tomodify an existing publication (SQL)
1. Connect to the database as a user who owns the publication or as a user
withDBA authority.
2. Connect to a database with DBA authority.
3. Executean ALTER PUBLICATIONstatement.
Example ♦Thefollowing statement adds the customer table to the pub_contact
publication.
ALTER PUBLICATION pub_contact (
ADD TABLE customer
)
☞Seealso
♦“ALTERPUBLICATIONstatement” [ASA SQL Reference, page 280]
♦“Publishingonly some rows using a WHERE clause” on page 96
♦“Publishingonly some rows using a subscription expression” on page 97
Dropping publications
Youcan drop a publication using either Sybase Central or the DROP
PUBLICATIONstatement. If you drop a publication, all subscriptions to
thatpublication are automatically deleted as well.
Youmust have DBA authority to drop a publication.
100