Sybase Anyware. SQL query to determine DB version

Question

What query or command to determine Sybase SQL Anyware version?

I use sqlsh + freetds as interactive client (in Emacs).

Answer 1

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.