In the development environment of a Sybase SQL Anywhere Database, it is simple to analyze and describe the rules of foreign keys. All necessary informations are stored in the system tables of the database. The information can be combined into a useful view.

The following short sql funtions show how to get the root directory within a Sybase Sql Anywhere Database. Note that these methods work on all operating systems. call sa_make_object ('function','SAQ_PATHSEPERATOR'); alter function SAQ_PATHSEPERATOR() returns char(1) begin return(if left(property('platform'),7) = 'Windows' then '\\' else '/' endif); end ; call sa_make_object( 'function', 'SAQ_ROOT_DIR' ); alter function SAQ_ROOT_DIR() [...]

Out‐of‐Box Performance SQL Anywhere 12 added the following features to  enhance database performance, leading to faster queries and efficient use of resources. Automatic Tuning of Server Threads Column Statistics Management Improved Remote Data Access Performance Enhanced Connection Pooling for Clients and HTTP Server Other Performance Enhancements And much more... Scalability and Monitoring Developer Productivity Advanced Data Synchronization Take a look [...]

An Interview with Eric Farrar Product Manager on Sybase’s SQL Anywhere Stephan: Hi Eric, First of all thank you very much for taking time to answer a few questions. Articles on your Blog indicate that you are not only a Product Manager but also an experienced developer. Maybe you can introduce yourself a little? Eric: [...]