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 ALTER DATABASE SCHEMA FROM FILE statement
• 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