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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Statement Reference

UltraLite ALTER TABLE statement Next Page

UltraLite ALTER PUBLICATION statement

Alters a publication. A publication identifies synchronized data in an UltraLite remote database.


ALTER PUBLICATION publication-name alterpub-clause

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


WHERE clause    If a WHERE clause is changed via this statement, only rows satisfying search-condition are considered for upload from the associated table during synchronization. See Search conditions in UltraLite.


If you do not specify a WHERE clause, every row in the table that has changed in UltraLite since the last synchronization is considered for upload.

Side effects

Automatic commit.

See also

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

   ADD TABLE customers