The SQL statements supported by UltraLite SQL are a subset of the statements supported by SQL Anywhere databases.
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.