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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » 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.

  • Using UltraLite SQL creates a transaction. A transaction consists of all changes (insert, update, and delete statements) since the last rollback or commit statement.

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