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. See SELECT statement [UltraLite] [UltraLiteJ].
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:
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |