Search code examples
sybasesybase-asa

Sybase Anyware. SQL query to determine DB version

What query or command to determine Sybase SQL Anyware version?

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

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.