VistaDB 6
VistaDB / Developer's Guide / How To Perform Common Tasks / How To - Determine your Database Engine Version
In This Topic
    How To - Determine your Database Engine Version
    In This Topic

    To determine the version of your database you should execute the following command:

    Query Database Engine Version
    Copy Code
    SELECT @@VERSION;
    

    The return will look something like this:

    VistaDB 6.0.0 - Build 6.0.0.1 for .Net 4.5.1 Copyright (C) 2009-2019 Gibraltar Software, Inc. All rights reserved.
    

    There are several parts to the database engine version -

    Part Means
    VistaDB 6.0.0
    
    The TSQL Version of the engine - this indicates the specific TSQL Language dialect and file format used by the engine.  This version can be used to identify whether or not a particular feature is supported by the engine.
    Build 6.0.0.1117
    
    The file version of the VistaDB engine.  This uniquely identifies a specific build of VistaDB which is for use when checking against VistaDB release notes.
    for .Net 4.5.1
    
    The minimum version of .NET the engine requires. 

    If your database is out of date and requires a pack the engine will throw an exception at the time the database is opened with a message:

    Database specification changed. Pack database to update 
    

    Packing the database will update the internal structures to the most current version.

    See Also