General Queries‎ > ‎

G13: List available vocabularies

This query returns list of available vocabularies.

Input:
<None>

Sample query run:
The following query returns list of standard vocabularies.
SELECT vocabulary_id,
       vocabulary_name
FROM   vocabulary.vocabulary 
WHERE  vocabulary_id <> 0
Output: Output field list:
 Field  Description
 vocabulary_id  OMOP Vocabulary ID
 vocabulary_name  Vocabulary name

Sample output record:
 Field  Value
 vocabulary_id  1
 vocabulary_name  SNOMED-CT
Comments