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

UltraLite statement categories

SQL statements are organized and identified by the initial word in a statement, which is almost always a verb. This makes the nature of the language into a set of imperative statements (commands) to the database. In UltraLite, supported SQL statements can be classified as follows:

• Data retrieval statements  Also known as queries, these statements allow select rows of data expressions from tables. Data retrieval is achieved with the SELECT statement. See UltraLite SELECT statement.

• Data manipulation statements  Allow you to change content in the database. Data manipulation is achieved with:

  • UltraLite DELETE statement
  • UltraLite INSERT statement
  • UltraLite UPDATE statement

• Data definition statements  Allow you to define the structure or schema of a database. The schema can be changed with:

  • UltraLite CREATE INDEX statement
  • UltraLite CREATE TABLE statement
  • UltraLite DROP INDEX statement
  • UltraLite DROP TABLE statement
  • UltraLite ALTER TABLE statement
  • UltraLite TRUNCATE TABLE statement

• Transaction control statements  Allow you to control transactions within your UltraLite application. Transaction control is achieved with:

  • UltraLite CHECKPOINT statement
  • UltraLite COMMIT statement
  • UltraLite ROLLBACK statement

• Synchronization management  Allow you to temporarily control synchronization with a MobiLink server. Synchronization management is achieved with:

  • UltraLite START SYNCHRONIZATION DELETE statement
  • UltraLite STOP SYNCHRONIZATION DELETE statement
  • UltraLite CREATE PUBLICATION statement
  • UltraLite ALTER PUBLICATION statement
  • UltraLite DROP PUBLICATION statement

• Expressions in UltraLite
• Operators in UltraLite