SQL

SQL Statements UltraLite supports several new statements. These new statements include:

ALTER TABLE In addition to creating tables with UltraLite SQL, you can now alter the definition with this statement. See ALTER TABLE statement [UltraLite] [UltraLiteJ].
ALTER/CREATE/DROP PUBLICATION UltraLite now supports the addition, creation, and deletion of publications with these three statements. See ALTER PUBLICATION statement [UltraLite][UltraLiteJ],CREATE PUBLICATION statement [UltraLite] [UltraLiteJ] and DROP PUBLICATION statement [UltraLite] [UltraLiteJ].
START/STOP SYNCHRONIZATION DELETE UltraLite SQL includes these statements. Use these statements to control how deletes are logged with MobiLink synchronization. See START SYNCHRONIZATION DELETE statement [UltraLite] [UltraLiteJ] and STOP SYNCHRONIZATION DELETE statement [UltraLite] [UltraLiteJ].

Named constraints Table constraints can now be named in the ALTER TABLE and CREATE TABLE statements. This permits modification of table and column constraints by changing individual constraints, rather than by modifying an entire table constraint. See ALTER TABLE statement [UltraLite] [UltraLiteJ] and CREATE TABLE statement [UltraLite] [UltraLiteJ].

Other SELECT statement enhancements The SELECT statement has been extended:

SELECT statements can now include START AT as part of the TOP clause. START AT provides additional flexibility in queries that explicitly limit the result set. See SELECT statement [UltraLite] [UltraLiteJ].
The DISTINCT clause has been enhanced to allow aggregate functions with this clause (for example, SUM, AVERAGE, MAX, and so on). If you use aggregate functions with this clause, you will significantly increase the execution time. See SELECT statement [UltraLite] [UltraLiteJ] and SQL functions.

UNION operator The UNION operator allows you to build a single result set from two or more queries into a single result set. By default, the UNION operator removes duplicate rows from the result set. See Combining sets with the UNION clause.