General Queries‎ > ‎

G12: List current vocabulary release number

This query returns current vocabulary release number.

Input:
<None>

Sample query run:
The following query returns release number of current vocabulary.
SELECT vocabulary_name 
FROM   vocabulary.vocabulary 
WHERE  vocabulary_id = 0
Output: 
Output field list:
 Field  Description
 vocabulary_name  Version number of current OMOP vocabulary release

Sample output record:
 Field  Value
 vocabulary_name  OMOP Vocabulary v4.3 Q2-2013
Comments