//MST table from mrconso, includes all fields except sab and lat. (a English version of MST)
 create table kh_mrconso_mst_en as 
   select CUI,TS,LUI,STT,SUI,ISPREF,AUI,SAUI,SCUI,SDUI,TTY,CODE,STR,SRL,SUPPRESS,CVF
          from mrconso
          where sab='MTHMST' and lat='ENG' order by cui

 //MST relationships table from mrrel, includes all fields except sab.
 create table kh_mrrel_mst_en as
    select CUI1,AUI1,STYPE1,REL,CUI2,AUI2,STYPE2,RELA,RUI,SRUI,SL,RG,DIR,SUPPRESS,CVF
           from mrrel
           where sab='MTHMST'

 //MST SN table from mrsty (all fields are included)
 create table kh_mrsty_mst_en as
    select * from mrsty where cui in (
       select cui from mrconso where sab='MTHMST' and lat='ENG'
       )


 //UMLS' view from mrconso
 create view kh_mrconso_umls_en as 
    select * from mrconso
             where sab!='MTHMST' and lat='ENG'
 
 //UMLS' view from mrrel
 create view kh_mrrel_umls_en as
    select * from mrrel
             where sab!='MTHMST'


 //UMLS' SN view from mrsty (all fields are included)
 create view kh_mrsty_umls_en as
    select * from mrsty where cui in (
       select cui from mrconso where sab !='MTHMST' and lat='ENG'
       )