Sybase Anyware. SQL query to determine DB version

sybase, sybase-asa

Solution

For databases, you can use the SYSHISTORY system view to find out what version the database was created at.

select version from SYSHISTORY where object_id = OBJ_ID_OF_DB

If you databases were migrated from earlier installations, and don't show the version number you expect, you probably could just create a small database, and take a look at the version history information.

Problem

What query or command to determine Sybase SQL Anyware version? I use sqlsh + freetds as interactive client (in Emacs).

Original source