ALTER PUBLICATION [ owner.]publication-name alterpub-clause, ...

alterpub-clause :
ADD article-definition
| ALTER article-definition
| { DELETE | DROP } TABLE [ owner.]table-name
| RENAME publication-name

article-definition :
TABLE table-name [ ( column-name, ... ) ]
[ WHERE search-condition ]
[ SUBSCRIBE BY expression ]
[ USING ( [PROCEDURE ] [ owner.][procedure-name ] 
  FOR UPLOAD { INSERT | DELETE | UPDATE }, ... ) ]

This statement is applicable only to MobiLink and SQL Remote.

The contribution to a publication from one table is called an article. Changes can be made to a publication by adding, modifying, or deleting articles, or by renaming the publication. If an article is modified, the entire definition of the modified article must be entered.

It is recommended that you perform a successful synchronization of a publication immediately before you alter it.

You cannot use the WHERE clause for publications that are defined as FOR DOWNLOAD ONLY or WITH SCRIPTED UPLOAD.

The SUBSCRIBE BY clause applies to SQL Remote only.

The USING clause is for scripted upload only.

You set options for a MobiLink publication with the ADD OPTION clause in the ALTER SYNCHRONIZATION SUBSCRIPTION statement or CREATE SYNCHRONIZATION SUBSCRIPTION statement.

When altering a MobiLink publication, an article can only be dropped after the execution of a START SYNCHRONIZATION SCHEMA CHANGE statement.

Must have DBA authority, or be the owner of the publication. Requires exclusive access to all tables referred to in the statement.

Automatic commit.

• CREATE PUBLICATION statement [MobiLink] [SQL Remote]
• DROP PUBLICATION statement [MobiLink] [SQL Remote]
• SQL Anywhere MobiLink clients: Publications
• UltraLite MobiLink clients: UltraLite client synchronization design
• Publications and articles
• ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
• CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
• ISYSSYNC system table
• START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]
• Changes to avoid on a running system

The following statement adds the Customers table to the pub_contact publication.

ALTER PUBLICATION pub_contact
   ADD TABLE Customers;