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 UltraLite ALTER TABLE statement.
ALTER/CREATE/DROP PUBLICATION UltraLite now supports the addition, creation, and deletion of publications with these three statements. See UltraLite ALTER PUBLICATION statement,UltraLite CREATE PUBLICATION statement and UltraLite DROP PUBLICATION statement.
START/STOP SYNCHRONIZATION DELETE UltraLite SQL includes these statements. Use these statements to control how deletes are logged with MobiLink synchronization. See UltraLite START SYNCHRONIZATION DELETE statementand UltraLite STOP SYNCHRONIZATION DELETE statement.
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 UltraLite ALTER TABLE statement and UltraLite CREATE TABLE statement.
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 UltraLite SELECT statement.
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 UltraLite SELECT statement and Alphabetical list of 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 statement.