Alter Table TMSYSTEM.G2004TYPTASTEN ADD CONSTRAINT  TMSYSTEM.TTNTTY_O2004TASTTYP_FK FOREIGN KEY (TTNTTY) REFERENCES TMSYSTEM.O2004TASTTYP(TTYNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2005ZEITPUNKT ADD CONSTRAINT  TMSYSTEM.TZUZPL_O2005ZEITMODELL_FK FOREIGN KEY (TZUZPL) REFERENCES TMSYSTEM.O2005ZEITMODELL(TZMNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2100TASLST ADD CONSTRAINT  TMSYSTEM.TTABCH_O2003BUCHCODE_FK FOREIGN KEY (TTABCH) REFERENCES TMSYSTEM.O2003BUCHCODE(TBCCOD) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2100TASLST ADD CONSTRAINT  TMSYSTEM.TTATTX_O2000TASTTEXTE_FK FOREIGN KEY (TTATTX) REFERENCES TMSYSTEM.O2000TASTTEXTE(TAZNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2100TASLST ADD CONSTRAINT  TMSYSTEM.TTATYP_G2004TYPTASTEN_FK FOREIGN KEY (TTATYP,TTATAS) REFERENCES TMSYSTEM.G2004TYPTASTEN(TTNTTY,TTNTAS) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2102UPLLST ADD CONSTRAINT  TMSYSTEM.TUWUPL_O2102UPLTAB_FK FOREIGN KEY (TUWUPL) REFERENCES TMSYSTEM.O2102UPLTAB(TUMNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2102UPLLST ADD CONSTRAINT  TMSYSTEM.TUWZPL_O2005ZEITMODELL_FK FOREIGN KEY (TUWZPL) REFERENCES TMSYSTEM.O2005ZEITMODELL(TZMNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2103DNLLST ADD CONSTRAINT  TMSYSTEM.DLLNAM_O2103DNLTAB_FK FOREIGN KEY (DLLNAM) REFERENCES TMSYSTEM.O2103DNLTAB(TDNNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.G2103DNLLST ADD CONSTRAINT  TMSYSTEM.DLLZPL_O2005ZEITMODELL_FK FOREIGN KEY (DLLZPL) REFERENCES TMSYSTEM.O2005ZEITMODELL(TZMNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.O1201FORMULAR ADD CONSTRAINT  TMSYSTEM.FMRFLD_TMS102FTX_FK FOREIGN KEY (FMRFLD) REFERENCES TMSYSTEM.TMS102FTX(FTXNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.O1803FRMSCHALTLST ADD CONSTRAINT  TMSYSTEM.FRMSFLFRM_O1201FORMULAR_FK FOREIGN KEY (FRMSFLFRM) REFERENCES TMSYSTEM.O1201FORMULAR(FMRNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.O1803FRMSCHALTLST ADD CONSTRAINT  TMSYSTEM.FRMSFLSCH_O1801SCHALT_FK FOREIGN KEY (FRMSFLSCH) REFERENCES TMSYSTEM.O1801SCHALT(SFLNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS100TBS ADD CONSTRAINT  TMSYSTEM.TBSFNR_TMS102FTX_FK FOREIGN KEY (TBSFNR) REFERENCES TMSYSTEM.TMS102FTX(FTXNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS100TBS ADD CONSTRAINT  TMSYSTEM.TBSTNA_TMS901TABELLEN_FK FOREIGN KEY (TBSTNA) REFERENCES TMSYSTEM.TMS901TABELLEN(TABNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS102WHL ADD CONSTRAINT  TMSYSTEM.FTXNUMSPR_TMS102FTX_FK FOREIGN KEY (FTXNUMSPR) REFERENCES TMSYSTEM.TMS102FTX(FTXNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS102WHL ADD CONSTRAINT  TMSYSTEM.FTXSPR_O1201SPRACHE_FK FOREIGN KEY (FTXSPR) REFERENCES TMSYSTEM.O1201SPRACHE(SPRNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS103FRM ADD CONSTRAINT  TMSYSTEM.FRMFLD_TMS100TBS_FK FOREIGN KEY (FRMFLD) REFERENCES TMSYSTEM.TMS100TBS(TBSFNA) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS103FRM ADD CONSTRAINT  TMSYSTEM.FRMNAM_O1201FORMULAR_FK FOREIGN KEY (FRMNAM) REFERENCES TMSYSTEM.O1201FORMULAR(FMRNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS103FRMRTR ADD CONSTRAINT  TMSYSTEM.RTRFRM_O1201FORMULAR_FK FOREIGN KEY (RTRFRM) REFERENCES TMSYSTEM.O1201FORMULAR(FMRNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS103FRMRTR ADD CONSTRAINT  TMSYSTEM.RTRNUM_O1201FORMULAR_FK FOREIGN KEY (RTRNUM) REFERENCES TMSYSTEM.O1201FORMULAR(FMRNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS103FRMTXT ADD CONSTRAINT  TMSYSTEM.FRMTXTFRM_O1201FORMULAR_FK FOREIGN KEY (FRMTXTFRM) REFERENCES TMSYSTEM.O1201FORMULAR(FMRNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS103FRMTXT ADD CONSTRAINT  TMSYSTEM.FRMTXTFTX_TMS102FTX_FK FOREIGN KEY (FRMTXTFTX) REFERENCES TMSYSTEM.TMS102FTX(FTXNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS104WEB ADD CONSTRAINT  TMSYSTEM.WEBANM_TMS111ANM_FK FOREIGN KEY (WEBANM,WEBLIZ,WEBMND) REFERENCES TMSYSTEM.TMS111ANM(ANMANM,ANMLIZ,ANMMND) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS113AWV ADD CONSTRAINT  TMSYSTEM.AWVSTO_TMS113STO_FK FOREIGN KEY (AWVSTO) REFERENCES TMSYSTEM.TMS113STO(STONUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS114TKD ADD CONSTRAINT  TMSYSTEM.TKDNAM_TMS1140TRM_FK FOREIGN KEY (TKDNAM,TKDLIZ,TKDMND) REFERENCES TMSYSTEM.TMS1140TRM(TRMNAM,TRMLIZ,TRMMND) ON DELETE CASCADE ;
Alter Table TMSYSTEM.TMS114TSM ADD CONSTRAINT  TMSYSTEM.TSMDNL_O2103DNLTAB_FK FOREIGN KEY (TSMDNL) REFERENCES TMSYSTEM.O2103DNLTAB(TDNNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS114TSM ADD CONSTRAINT  TMSYSTEM.TSMSAL_O2101SALTAB_FK FOREIGN KEY (TSMSAL) REFERENCES TMSYSTEM.O2101SALTAB(TSLNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS114TSM ADD CONSTRAINT  TMSYSTEM.TSMTYP_O2007TRMTYP_FK FOREIGN KEY (TSMTYP) REFERENCES TMSYSTEM.O2007TRMTYP(TMTNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS114TSM ADD CONSTRAINT  TMSYSTEM.TSMUPL_O2102UPLTAB_FK FOREIGN KEY (TSMUPL) REFERENCES TMSYSTEM.O2102UPLTAB(TUMNAM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS1140COM ADD CONSTRAINT  TMSYSTEM.COMNAM_TMS1140TRM_FK FOREIGN KEY (COMNAM,COMLIZ,COMMND) REFERENCES TMSYSTEM.TMS1140TRM(TRMNAM,TRMLIZ,TRMMND) ON DELETE CASCADE ;
Alter Table TMSYSTEM.TMS1140SLT ADD CONSTRAINT  TMSYSTEM.SLTTRM_TMS1140TRM_FK FOREIGN KEY (SLTTRM,SLTLIZ,SLTMND) REFERENCES TMSYSTEM.TMS1140TRM(TRMNAM,TRMLIZ,TRMMND) ON DELETE CASCADE ;
Alter Table TMSYSTEM.TMS119MSD ADD CONSTRAINT  TMSYSTEM.MSDSAL_TMS119MST_FK FOREIGN KEY (MSDSAL,MSDLIZ,MSDMND) REFERENCES TMSYSTEM.TMS119MST(MSTNAM,MSTLIZ,MSTMND) ON DELETE CASCADE ;
Alter Table TMSYSTEM.TMS119MST ADD CONSTRAINT  TMSYSTEM.MSTTTP_O2007TRMTYP_FK FOREIGN KEY (MSTTTP) REFERENCES TMSYSTEM.O2007TRMTYP(TMTNAM) ON DELETE SET NULL ;
Alter Table TMSYSTEM.TMS133KAL ADD CONSTRAINT  TMSYSTEM.KALDTM_TMS133BAK_FK FOREIGN KEY (KALDTM) REFERENCES TMSYSTEM.TMS133BAK(BAKDTM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS133KAL ADD CONSTRAINT  TMSYSTEM.KALNUM_TMS135MUW_FK FOREIGN KEY (KALNUM) REFERENCES TMSYSTEM.TMS135MUW(MUWKAL) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS133KAL ADD CONSTRAINT  TMSYSTEM.KALTTP_TMS132TTP_FK FOREIGN KEY (KALTTP) REFERENCES TMSYSTEM.TMS132TTP(TTPNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS137WC2 ADD CONSTRAINT  TMSYSTEM.WC2KAL_TMS135MUW_FK FOREIGN KEY (WC2KAL) REFERENCES TMSYSTEM.TMS135MUW(MUWKAL) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS137WC2 ADD CONSTRAINT  TMSYSTEM.WC2TTP_TMS132TTP_FK FOREIGN KEY (WC2TTP) REFERENCES TMSYSTEM.TMS132TTP(TTPNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS301ASW ADD CONSTRAINT  TMSYSTEM.ASWNUM_TMS113AWV_FK FOREIGN KEY (ASWNUM) REFERENCES TMSYSTEM.TMS113AWV(AWVNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS301AWB ADD CONSTRAINT  TMSYSTEM.AWBASW_TMS113AWV_FK FOREIGN KEY (AWBASW) REFERENCES TMSYSTEM.TMS113AWV(AWVNUM) ON DELETE CASCADE ;
Alter Table TMSYSTEM.TMS401ZLK ADD CONSTRAINT  TMSYSTEM.ZLKTRM_TMS1140TRM_FK FOREIGN KEY (ZLKTRM,ZLKLIZ,ZLKMND) REFERENCES TMSYSTEM.TMS1140TRM(TRMNAM,TRMLIZ,TRMMND) ON DELETE CASCADE ;
Alter Table TMSYSTEM.TMS401ZLS ADD CONSTRAINT  TMSYSTEM.ZLSTFR_TMS403ZBK_FK FOREIGN KEY (ZLSTFR) REFERENCES TMSYSTEM.TMS403ZBK(ZBKNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS401ZLS ADD CONSTRAINT  TMSYSTEM.ZLSTVR_TMS403ZBK_FK FOREIGN KEY (ZLSTVR) REFERENCES TMSYSTEM.TMS403ZBK(ZBKNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS402ZKO ADD CONSTRAINT  TMSYSTEM.ZKOKAL_TMS135MUW_FK FOREIGN KEY (ZKOKAL) REFERENCES TMSYSTEM.TMS135MUW(MUWKAL) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS402ZKO ADD CONSTRAINT  TMSYSTEM.ZKOTFS_TMS403ZBK_FK FOREIGN KEY (ZKOTFS) REFERENCES TMSYSTEM.TMS403ZBK(ZBKNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS402ZKO ADD CONSTRAINT  TMSYSTEM.ZKOTVR_TMS403ZBK_FK FOREIGN KEY (ZKOTVR) REFERENCES TMSYSTEM.TMS403ZBK(ZBKNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS402ZPK ADD CONSTRAINT  TMSYSTEM.ZPKDTM_TMS133BAK_FK FOREIGN KEY (ZPKDTM) REFERENCES TMSYSTEM.TMS133BAK(BAKDTM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS402ZPK ADD CONSTRAINT  TMSYSTEM.ZPKTRM_TMS401ZLS_FK FOREIGN KEY (ZPKTRM,ZPKLES) REFERENCES TMSYSTEM.TMS401ZLS(ZLSTRM,ZLSLES) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS402ZPK ADD CONSTRAINT  TMSYSTEM.ZPKZUS_TMS405ZZS_PK FOREIGN KEY (ZPKZUS) REFERENCES TMSYSTEM.TMS405ZZS(ZZSNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS402ZUZ ADD CONSTRAINT  TMSYSTEM.ZUZNUM_TMS402ZZZ_FK FOREIGN KEY (ZUZNUM) REFERENCES TMSYSTEM.TMS402ZZZ(ZZZNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS404ZBR ADD CONSTRAINT  TMSYSTEM.ZBRTTP_TMS132TTP_FK FOREIGN KEY (ZBRTTP) REFERENCES TMSYSTEM.TMS132TTP(TTPNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS404ZBR ADD CONSTRAINT  TMSYSTEM.ZBRZBK_TMS403ZBK_FK FOREIGN KEY (ZBRZBK) REFERENCES TMSYSTEM.TMS403ZBK(ZBKNUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS404ZBR ADD CONSTRAINT  TMSYSTEM.ZBRZKO_TMS402ZKO_FK FOREIGN KEY (ZBRZKO) REFERENCES TMSYSTEM.TMS402ZKO(ZKONUM) ON DELETE NO ACTION ;
Alter Table TMSYSTEM.TMS801EMA ADD CONSTRAINT  TMSYSTEM.SCDLIZMND_TMS800SCD_FK FOREIGN KEY (EMASCD,EMALIZ,EMAMND,EMASBE) REFERENCES TMSYSTEM.TMS800SCD(SCDNAM,SCDLIZ,SCDMND,SCDSBE) ON DELETE NO ACTION ;
