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

SQL Anywhere 11.0.1 (Français) » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL statements

 

UltraLite ALTER PUBLICATION statement

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
Example

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

ALTER PUBLICATION pub_contact
   ADD TABLE Customers;