Altering existing publications

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.

To modify the properties of existing publications or articles (Sybase Central)

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.
Configure the desired properties.

To add articles (Sybase Central)

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.

To remove articles (Sybase Central)

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.

To modify an existing publication (SQL)

Connect to the database as a user who owns the publication or as a user with DBA authority.
Execute an ALTER PUBLICATION statement.

Example

The following statement adds the Customers table to the PubContacts publication.
ALTER PUBLICATION PubContacts ( ADD TABLE Customers );

Altering existing publications

Example

See also