Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL statements

ALTER PUBLICATION statement [UltraLite]

Alters a publication.

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
Remarks

A publication identifies data in a remote database that is to be synchronized.

Side effects

Automatic commit.

Example

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

ALTER PUBLICATION pub_contact
   ADD TABLE Customers