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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference

 

UltraLite SQL statements

The SQL statements supported by UltraLite SQL are a subset of the statements supported by SQL Anywhere databases.

Before you begin
  • Tables in UltraLite do not support the concept of an owner. As a convenience for existing SQL and for SQL that is programmatically generated, UltraLite still allows the syntax owner.table-name. However, the owner is not checked because table owners are not supported in UltraLite.

  • UltraLite SQL statement documentation follows the same syntax conventions used by SQL Anywhere statements. Ensure you understand these conventions and how they are used to represent SQL syntax. See Syntax conventions.

  • Using UltraLite SQL creates a transaction. A transaction consists of all changes (INSERTs, UPDATEs, and DELETEs) since the last ROLLBACK or COMMIT. See UltraLite transaction processing.

    These changes can be made permanent by executing a COMMIT. A ROLLBACK statement causes the changes to be removed. See UltraLite COMMIT statement and UltraLite ROLLBACK statement.

  • If you are looking for statements used by Interactive SQL, see SQL statements. Statements used by Interactive SQL have [Interactive SQL] after the statement name. For example, CONFIGURE statement [Interactive SQL].


UltraLite statement categories
UltraLite ALTER DATABASE SCHEMA FROM FILE statement
UltraLite ALTER PUBLICATION statement
UltraLite ALTER SYNCHRONIZATION PROFILE statement
UltraLite ALTER TABLE statement
UltraLite CHECKPOINT statement
UltraLite COMMIT statement
UltraLite CREATE INDEX statement
UltraLite CREATE PUBLICATION statement
UltraLite CREATE SYNCHRONIZATION PROFILE statement
UltraLite CREATE TABLE statement
UltraLite DELETE statement
UltraLite DROP INDEX statement
UltraLite DROP PUBLICATION statement
UltraLite DROP SYNCHRONIZATION PROFILE statement
UltraLite DROP TABLE statement
UltraLite FROM clause
UltraLite INSERT statement
UltraLite LOAD TABLE statement
UltraLite ROLLBACK statement
UltraLite SELECT statement
UltraLite SET OPTION statement
UltraLite START SYNCHRONIZATION DELETE statement
UltraLite STOP SYNCHRONIZATION DELETE statement
UltraLite SYNCHRONIZE statement
UltraLite TRUNCATE TABLE statement
UltraLite UNION statement
UltraLite UPDATE statement