CODEWITHSUNDEEP
sybasesybase-asa
gavenkoa
gavenkoa

Reputation: 48753

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).

Upvotes: 4

Views: 5521

Answers (1)

Mike Gardner
Mike Gardner

Reputation: 6651

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.

Upvotes: 4

Related Questions