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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility


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.

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