|
After you have created a publication, you can alter it by adding, modifying, or deleting articles, or by renaming the publication. If an article is modified, the entire specification of the modified article must be entered.
You can perform these tasks using Sybase Central or with the ALTER PUBLICATION statement in Interactive SQL.
Connect to the database as a user who owns the publication or as a user with DBA authority.
Right-click the publication or article and choose Properties from the popup menu.
Configure the desired properties.
Connect to the database as a user who owns the publication or as a user with DBA authority.
In the left pane, open the Publications folder.
Select the publication you want to add an article to.
From the File menu, choose New > Article.
The Create Article wizard appears.
In the Create Article wizard, do the following:
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).
Click Finish to create the article.
Connect to the database as a user who owns the publication or as a user with DBA authority.
Open the Publications folder.
Select the publication you want to remove an article from.
Right-click the article you want to delete and choose Delete from the popup menu.
Connect to the database as a user who owns the publication or as a user with DBA authority.
Execute an ALTER PUBLICATION statement.
The following statement adds the Customers table to the PubContacts publication.
ALTER PUBLICATION PubContacts ( ADD TABLE Customers )