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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL statement reference


UltraLite CREATE PUBLICATION statement

Use this statement to create a publication. A publication identifies synchronized data in an UltraLite remote database.

CREATE PUBLICATION publication-name
( TABLE table-name [ WHERE search-condition ], ... ) 

TABLE clause   Use the table to include a TABLE in the publication. There is no limit to the number of TABLE clauses

WHERE clause   If a WHERE clause is specified, 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.


A publication establishes tables that are synchronized during a single synchronization operation, and determines which data is uploaded to the MobiLink server. The MobiLink server may send back rows for these (and only these) tables during its download session; however, rows that are downloaded do not have to satisfy the WHERE clause for a table.

Only entire tables can be published. You cannot publish specific columns of a table in UltraLite.

Side effects
See also

The following statement publishes all the columns and rows of two tables.

   TABLE Contacts,
   TABLE Customers

The following statement publishes only the rows of the Customers table where the State column contains MN.

   TABLE Customers 
   WHERE State = 'MN'