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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility


Transact-SQL-compatible databases

You can eliminate some differences in behavior between SQL Anywhere and Adaptive Server Enterprise by selecting appropriate options when creating a database or, if you are working on an existing database, when rebuilding the database. You can control other differences by setting connection level options using the SET TEMPORARY OPTION statement in SQL Anywhere or the SET statement in Adaptive Server Enterprise.

 Make the database case sensitive
 Ignore trailing blanks in comparisons
 Remove historical system views
 See also

Creating a Transact-SQL-compatible database (Sybase Central)
Creating a Transact-SQL-compatible database (command line)
Creating a Transact-SQL-compatible database (SQL)
Options for Transact-SQL compatibility
Case sensitivity
Compatible object names
The special Transact-SQL TIMESTAMP column and data type
The special IDENTITY column