Subject RE: [firebird-support] Is there way to get (with SQL) firebird version??
Author Leyne, Sean
Tommi,

> Is there some simple select SQL I can verify that server is
> Firebird/Interbase and if Firebird which version of it???
>
> Some selects to the RDB$ tables maybe...

In v2.1 there is a new RDB$GET_Context call which will return the
Firebird version.

In older versions there is no definitive way to determine the version,
though there are some clues which can be used to give you some general
idea of the version (If RDB$GET_Context is defined as UDF, then version
> 2.x else version 1.x . Further if RDB$GET_Context( 'System','ODS') =
11.1 then version = 2.1 else 2.0.x)


Sean