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 statement and 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:
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|