CREATE / DROP / ALTER USER added   See:

• CREATE USER statement [UltraLite]
• DROP USER statement [UltraLite]
• ALTER USER statement [UltraLite]

New table constraint for CREATE TABLE and ALTER TABLE   An additional table constraint (SYNCHRONIZE ON | OFF | ALL) can be specified in a CREATE TABLE or an ALTER TABLE statement. See:

• CREATE TABLE statement [UltraLite] [UltraLiteJ]
• ALTER TABLE statement [UltraLite] [UltraLiteJ]

IF EXISTS clause added to DROP statements   A new IF EXISTS clause can now optionally be specified in DROP INDEX, DROP PUBLICATION, DROP SYNCHRONIZATION PROFILE, and DROP TABLE statements. See:

• DROP INDEX statement [UltraLite] [UltraLiteJ]
• DROP PUBLICATION statement [UltraLite] [UltraLiteJ]
• DROP SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ]
• DROP TABLE statement [UltraLite] [UltraLiteJ]

IF NOT EXISTS clause added to CREATE statements   A new IF NOT EXISTS clause can now optionally be specified in CREATE TABLE, CREATE INDEX, CREATE PUBLICATION, and CREATE SYNCHRONIZATION PROFILE statements. See:

• CREATE TABLE statement [UltraLite] [UltraLiteJ]
• CREATE INDEX statement [UltraLite] [UltraLiteJ]
• CREATE PUBLICATION statement [UltraLite] [UltraLiteJ]
• CREATE SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ]

CREATE SYNCHRONIZATION PROFILE now also supports OR REPLACE clause   The CREATE SYNCHRONIZATION PROFILE statement now also support the option to replace a table. See CREATE SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ].

COUNT_UPLOAD_ROWS function added   COUNT_UPLOAD_ROWS allows you to query the number of rows that will be uploaded in the next synchronization. See COUNT_UPLOAD_ROWS function [Aggregate].