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:
Data definition statements Allow you to define the structure or schema of a database. The schema can be changed with:
Transaction control statements Allow you to control transactions within your UltraLite application. Transaction control is achieved with:
Synchronization management Allow you to temporarily control synchronization with a MobiLink server. Synchronization management is achieved with: