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 supports many SQL language features and elements.


In this section:
    UltraLite SQL language elements
    UltraLite supports many SQL elements.
    SQL data types
    UltraLite supports a subset of the data types available in SQL Anywhere.
    Spatial data types
    Spatial data is data that describes the position, shape, and orientation of objects in a defined space. UltraLite provides storage and data management features for spatial data, in the form of points, allowing you to store information such as geographic locations and routing information.
    User-defined data types and their equivalents
    Unlike SQL Anywhere databases, UltraLite does not support user-defined data types.
    SQL functions
    Functions are used to return information from the database. They can be called anywhere an expression is allowed.
    UltraLite SQL statements
    The SQL statements supported by UltraLite SQL are a subset of the statements supported by SQL Anywhere databases.