Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures


xp_msver system procedure

Retrieves version and name information about the database server.

xp_msver( string )
  • string   The string must be one of the following, enclosed in string delimiters.

    Argument Description
    ProductName The name of the product (SQL Anywhere).
    ProductVersion The version number, followed by the build number. The format is as follows:
    CompanyName Returns the following string:
    iAnywhere Solutions, Inc.
    FileDescription Returns the name of the product, followed by the name of the operating system.
    LegalCopyright Returns a copyright string for the software.
    LegalTrademarks Returns trademark information for the software.


xp_msver returns product, company, version, and other information.



See also

The following statement requests the version and operating system description:

SELECT xp_msver( 'ProductVersion') Version,
   xp_msver( 'FileDescription' ) Description;

Sample output is as follows:

Version Description SQL Anywhere Windows XP