Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL statements

UltraLite statement categories

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:

  • 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:

    • INSERT
    • UPDATE
    • DELETE
  • Data definition statements

    Allow you to define the structure or schema of a database. The schema can be changed with the following statements:

    • ALTER DATABASE SCHEMA FROM FILE
    • CREATE INDEX
    • CREATE TABLE
    • DROP INDEX
    • DROP TABLE
    • ALTER TABLE
    • TRUNCATE TABLE
  • Transaction control statements

    Allow you to control transactions within your UltraLite application. Transaction control is achieved with the following statements:

    • CHECKPOINT
    • COMMIT
    • ROLLBACK
  • Synchronization management

    Allow you to temporarily control synchronization with a MobiLink server. Synchronization management is achieved with:

    • START SYNCHRONIZATION DELETE
    • STOP SYNCHRONIZATION DELETE
    • CREATE PUBLICATION
    • ALTER PUBLICATION
    • DROP PUBLICATION