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.

Syntax

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

Parameters

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.

Remarks

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
Example

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

ALTER PUBLICATION pub_contact
   ADD TABLE customers