SQL Anywhere features that differ from other SQL implementations

SQL Anywhere offers rich SQL functionality, including: per-row, per-statement, and INSTEAD OF triggers; SQL stored procedures and user-defined functions; RECURSIVE UNION queries; common table expressions; table functions; LATERAL derived tables; integrated full-text search; WINDOW aggregate functions; regular-expression searching; XML support; materialized views; snapshot isolation; and referential integrity. This section describes some specific features supported by SQL Anywhere that differ from other SQL database implementations.

 Dates
 Entity and referential integrity
 Unique indexes
 Joins
 CHAR, NCHAR, and BINARY data types
 UPDATE statements
 Table functions
 Materialized views
 Cursors
 Alias references
 Snapshot isolation