Use this statement to alter a publication. A publication identifies data in a remote database that is to be synchronized.

Syntax

ALTER PUBLICATION publication-name alterpub-clause

alterpub-clause :
  ADD TABLE table-name [ WHERE search-condition ]
| ALTER TABLE table-name  [ WHERE search-condition ]
| { DROP | DELETE } TABLE table-name
| RENAME publication-name

Side effects

Automatic commit.

See also

• Search conditions in UltraLite
• Designing synchronization in UltraLite
• UltraLite CREATE PUBLICATION statement
• UltraLite DROP PUBLICATION statement
• UltraLite START SYNCHRONIZATION DELETE statement
• UltraLite STOP SYNCHRONIZATION DELETE statement

Example

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

ALTER PUBLICATION pub_contact
   ADD TABLE Customers;