SQL statements are organized and identified by the initial word in a 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:
Data definition statements Allow you to define the structure or schema of a database. The schema can be changed with the following statements:
Transaction control statements Allow you to control transactions within your UltraLite application. Transaction control is achieved with the following statements:
Synchronization management Allow you to temporarily control synchronization with a MobiLink server. Synchronization management is achieved with:
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |