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