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:
Also known as queries. These statements allow select rows of data expressions from tables. Data retrieval is achieved with the SELECT statement.
Allow you to change content in the database. Data manipulation is achieved with the following statements:
Allow you to define the structure or schema of a database. The schema can be changed with the following statements:
Allow you to control transactions within your UltraLite application. Transaction control is achieved with the following statements:
Allow you to temporarily control synchronization with a MobiLink server. Synchronization management is achieved with: