SQL Remote User's Guide
SQL Remote Design for Adaptive Server Anywhere
Publishing data
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 from the popup menu.
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
The Article Creation wizard appears.
In the Article Creation 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.
Connect to a database with DBA authority.
Execute an ALTER PUBLICATION statement.
The following statement adds the customer table to the pub_contact publication.
ALTER PUBLICATION pub_contact ( ADD TABLE customer )
See also