User's Manual

♦ Choose a table and click Next.
♦ Choose the columns for the article. Click Next.
♦ Enter a WHERE clause (if desired). Click Next.
♦ Create a SUBSCRIBE BY restriction (if desired).
6. Click Finish to create the article.
❖ To remove articles (Sybase Central)
1. Connect to the database as a user who owns the publication or as a user
with DBA 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
popup menu.
❖ To modify an existing publication (SQL)
1. Connect to the database as a user who owns the publication or as a user
with DBA authority.
2. Connect to a database with DBA authority.
3. Execute an ALTER PUBLICATION statement.
Example
♦ The following statement adds the customer table to the pub_contact
publication.
ALTER PUBLICATION pub_contact (
ADD TABLE customer
)
☞ See also
♦ “ALTER PUBLICATION statement” [ASA SQL Reference, page 280]
♦ “Publishing only some rows using a WHERE clause” on page 96
♦ “Publishing only some rows using a subscription expression” on page 97
Dropping publications
You can drop a publication using either Sybase Central or the DROP
PUBLICATION statement. If you drop a publication, all subscriptions to
that publication are automatically deleted as well.
You must have DBA authority to drop a publication.
100