VistaDB 5
Gibraltar VistaDB > Developer's Guide > How To Perform Common Tasks > How To - Determine your Database Engine Version
How To - Determine your Database Engine Version

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 5.0.0 - Build 5.0.0.1117 for .Net 4.0 Copyright (C) 2009-2013 Gibraltar Software, Inc. All rights reserved.

There are several parts to the database engine version -

Part Means
VistaDB 5.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 5.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.0
The minimum version of .NET the engine requires.  As of VistaDB 5.0 there are a .NET 2.0 and a .NET 4.0 version of the engine.

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