UltraLite statement categories

SQL statements are organized and identified by the initial keyword in the statement, which is almost always a verb. This action-oriented syntax 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.

• Data manipulation statements

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

  • INSERT
  • UPDATE
  • DELETE
• Data definition statements

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

  • ALTER DATABASE SCHEMA FROM FILE
  • CREATE INDEX
  • CREATE TABLE
  • DROP INDEX
  • DROP TABLE
  • ALTER TABLE
  • TRUNCATE TABLE
• Transaction control statements

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

  • CHECKPOINT
  • COMMIT
  • ROLLBACK
• Synchronization management

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

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