if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC2演習M_TC1システムM]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC2演習M] DROP CONSTRAINT FK_TC2演習M_TC1システムM GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC3学生グループM_TC1システムM]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC3学生グループM] DROP CONSTRAINT FK_TC3学生グループM_TC1システムM GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC9区分M_TC1システムM]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC9区分M] DROP CONSTRAINT FK_TC9区分M_TC1システムM GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC9文書種類M_TC1システムM]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC9文書種類M] DROP CONSTRAINT FK_TC9文書種類M_TC1システムM GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC9名刺デザインM_TC1システムM]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC9名刺デザインM] DROP CONSTRAINT FK_TC9名刺デザインM_TC1システムM GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTM名刺データF_TC1システムM]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTM名刺データF] DROP CONSTRAINT FK_TTM名刺データF_TC1システムM GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC4演習許可学生グループM_TC2演習M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC4演習許可学生グループM] DROP CONSTRAINT FK_TC4演習許可学生グループM_TC2演習M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC6演習履歴M_TC2演習M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC6演習履歴M] DROP CONSTRAINT FK_TC6演習履歴M_TC2演習M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TDA会社M_TC2演習M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TDA会社M] DROP CONSTRAINT FK_TDA会社M_TC2演習M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TDA勘定科目M_TC2演習M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TDA勘定科目M] DROP CONSTRAINT FK_TDA勘定科目M_TC2演習M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TDA市場M_TC2演習M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TDA市場M] DROP CONSTRAINT FK_TDA市場M_TC2演習M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TDA商品M_TC2演習M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TDA商品M] DROP CONSTRAINT FK_TDA商品M_TC2演習M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TDA報告書書式M_TC2演習M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TDA報告書書式M] DROP CONSTRAINT FK_TDA報告書書式M_TC2演習M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TC5学生M_TC3学生グループM]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TC5学生M] DROP CONSTRAINT FK_TC5学生M_TC3学生グループM GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGA手形F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGA手形F] DROP CONSTRAINT FK_TGA手形F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGA入出庫TRN_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGA入出庫TRN] DROP CONSTRAINT FK_TGA入出庫TRN_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGB銀行口座F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGB銀行口座F] DROP CONSTRAINT FK_TGB銀行口座F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGC運送契約F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGC運送契約F] DROP CONSTRAINT FK_TGC運送契約F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGC寄託者台帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGC寄託者台帳F] DROP CONSTRAINT FK_TGC寄託者台帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGC出庫F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGC出庫F] DROP CONSTRAINT FK_TGC出庫F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGC保険契約F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGC保険契約F] DROP CONSTRAINT FK_TGC保険契約F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGK現金入出金TRN_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGK現金入出金TRN] DROP CONSTRAINT FK_TGK現金入出金TRN_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSA仕入売上書類F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSA仕入売上書類F] DROP CONSTRAINT FK_TSA仕入売上書類F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSB銀行取引申込書類F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSB銀行取引申込書類F] DROP CONSTRAINT FK_TSB銀行取引申込書類F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSC運送書類F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSC運送書類F] DROP CONSTRAINT FK_TSC運送書類F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSC運送費請求書F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSC運送費請求書F] DROP CONSTRAINT FK_TSC運送費請求書F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSC運送費請求書手動F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSC運送費請求書手動F] DROP CONSTRAINT FK_TSC運送費請求書手動F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK帳簿_合計残高試算表F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK帳簿_合計残高試算表F] DROP CONSTRAINT FK_TSK帳簿_合計残高試算表F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK帳簿_仕訳集計表F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK帳簿_仕訳集計表F] DROP CONSTRAINT FK_TSK帳簿_仕訳集計表F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK帳簿_仕訳日記帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK帳簿_仕訳日記帳F] DROP CONSTRAINT FK_TSK帳簿_仕訳日記帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK帳簿_総勘定元帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK帳簿_総勘定元帳F] DROP CONSTRAINT FK_TSK帳簿_総勘定元帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK帳簿_損益計算書F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK帳簿_損益計算書F] DROP CONSTRAINT FK_TSK帳簿_損益計算書F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK帳簿_貸借対照表F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK帳簿_貸借対照表F] DROP CONSTRAINT FK_TSK帳簿_貸借対照表F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK帳簿_八桁精算表F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK帳簿_八桁精算表F] DROP CONSTRAINT FK_TSK帳簿_八桁精算表F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK伝票F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK伝票F] DROP CONSTRAINT FK_TSK伝票F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_現金出納帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_現金出納帳F] DROP CONSTRAINT FK_TSK補助簿_現金出納帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_仕入帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_仕入帳F] DROP CONSTRAINT FK_TSK補助簿_仕入帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_支払手形記入帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_支払手形記入帳F] DROP CONSTRAINT FK_TSK補助簿_支払手形記入帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_受取手形記入帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_受取手形記入帳F] DROP CONSTRAINT FK_TSK補助簿_受取手形記入帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_商品有高帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_商品有高帳F] DROP CONSTRAINT FK_TSK補助簿_商品有高帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_当座預金出納帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_当座預金出納帳F] DROP CONSTRAINT FK_TSK補助簿_当座預金出納帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_買掛金元帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_買掛金元帳F] DROP CONSTRAINT FK_TSK補助簿_買掛金元帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_売掛金元帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_売掛金元帳F] DROP CONSTRAINT FK_TSK補助簿_売掛金元帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK補助簿_売上帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK補助簿_売上帳F] DROP CONSTRAINT FK_TSK補助簿_売上帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTA社員台帳F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTA社員台帳F] DROP CONSTRAINT FK_TTA社員台帳F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTA損益計画F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTA損益計画F] DROP CONSTRAINT FK_TTA損益計画F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTK記帳チェックF_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTK記帳チェックF] DROP CONSTRAINT FK_TTK記帳チェックF_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTK摘要M_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTK摘要M] DROP CONSTRAINT FK_TTK摘要M_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTL合併残高F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTL合併残高F] DROP CONSTRAINT FK_TTL合併残高F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTM名刺データ2F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTM名刺データ2F] DROP CONSTRAINT FK_TTM名刺データ2F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTXメールF_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTXメールF] DROP CONSTRAINT FK_TTXメールF_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTX文書F_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TTX文書F] DROP CONSTRAINT FK_TTX文書F_TDA会社M GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGA入出庫明細TRN_TGA入出庫TRN]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGA入出庫明細TRN] DROP CONSTRAINT FK_TGA入出庫明細TRN_TGA入出庫TRN GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TGB銀行口座入出金TRN_TGB銀行口座F]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TGB銀行口座入出金TRN] DROP CONSTRAINT FK_TGB銀行口座入出金TRN_TGB銀行口座F GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSA仕入売上書類明細F_TSA仕入売上書類F]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSA仕入売上書類明細F] DROP CONSTRAINT FK_TSA仕入売上書類明細F_TSA仕入売上書類F GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSC運送書類明細F_TSC運送書類F]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSC運送書類明細F] DROP CONSTRAINT FK_TSC運送書類明細F_TSC運送書類F GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSC運送費請求書手動明細F_TSC運送費請求書手動F]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSC運送費請求書手動明細F] DROP CONSTRAINT FK_TSC運送費請求書手動明細F_TSC運送費請求書手動F GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK伝票仕入売上明細F_TSK伝票F]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK伝票仕入売上明細F] DROP CONSTRAINT FK_TSK伝票仕入売上明細F_TSK伝票F GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TSK伝票明細F_TSK伝票F]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TSK伝票明細F] DROP CONSTRAINT FK_TSK伝票明細F_TSK伝票F GO ALTER TABLE [dbo].[TC2演習M] ADD CONSTRAINT [FK_TC2演習M_TC1システムM] FOREIGN KEY ( [システムCD] ) REFERENCES [dbo].[TC1システムM] ( [システムCD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TC3学生グループM] ADD CONSTRAINT [FK_TC3学生グループM_TC1システムM] FOREIGN KEY ( [システムCD] ) REFERENCES [dbo].[TC1システムM] ( [システムCD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TC4演習許可学生グループM] ADD CONSTRAINT [FK_TC4演習許可学生グループM_TC2演習M] FOREIGN KEY ( [システムCD], [演習CD] ) REFERENCES [dbo].[TC2演習M] ( [システムCD], [演習CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TC5学生M] ADD CONSTRAINT [FK_TC5学生M_TC3学生グループM] FOREIGN KEY ( [システムCD], [学生グループCD] ) REFERENCES [dbo].[TC3学生グループM] ( [システムCD], [学生グループCD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TC6演習履歴M] ADD CONSTRAINT [FK_TC6演習履歴M_TC2演習M] FOREIGN KEY ( [システムCD], [演習CD] ) REFERENCES [dbo].[TC2演習M] ( [システムCD], [演習CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TC9区分M] ADD CONSTRAINT [FK_TC9区分M_TC1システムM] FOREIGN KEY ( [システムCD] ) REFERENCES [dbo].[TC1システムM] ( [システムCD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TC9名刺デザインM] ADD CONSTRAINT [FK_TC9名刺デザインM_TC1システムM] FOREIGN KEY ( [システムCD] ) REFERENCES [dbo].[TC1システムM] ( [システムCD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TC9文書種類M] ADD CONSTRAINT [FK_TC9文書種類M_TC1システムM] FOREIGN KEY ( [システムCD] ) REFERENCES [dbo].[TC1システムM] ( [システムCD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TDA会社M] ADD CONSTRAINT [FK_TDA会社M_TC2演習M] FOREIGN KEY ( [システムCD], [演習CD] ) REFERENCES [dbo].[TC2演習M] ( [システムCD], [演習CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TDA勘定科目M] ADD CONSTRAINT [FK_TDA勘定科目M_TC2演習M] FOREIGN KEY ( [システムCD], [演習CD] ) REFERENCES [dbo].[TC2演習M] ( [システムCD], [演習CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TDA商品M] ADD CONSTRAINT [FK_TDA商品M_TC2演習M] FOREIGN KEY ( [システムCD], [演習CD] ) REFERENCES [dbo].[TC2演習M] ( [システムCD], [演習CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TDA報告書書式M] ADD CONSTRAINT [FK_TDA報告書書式M_TC2演習M] FOREIGN KEY ( [システムCD], [演習CD] ) REFERENCES [dbo].[TC2演習M] ( [システムCD], [演習CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TDA市場M] ADD CONSTRAINT [FK_TDA市場M_TC2演習M] FOREIGN KEY ( [システムCD], [演習CD] ) REFERENCES [dbo].[TC2演習M] ( [システムCD], [演習CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGA入出庫TRN] ADD CONSTRAINT [FK_TGA入出庫TRN_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGA入出庫明細TRN] ADD CONSTRAINT [FK_TGA入出庫明細TRN_TGA入出庫TRN] FOREIGN KEY ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) REFERENCES [dbo].[TGA入出庫TRN] ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGA手形F] ADD CONSTRAINT [FK_TGA手形F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGB銀行口座F] ADD CONSTRAINT [FK_TGB銀行口座F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [銀行CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGB銀行口座入出金TRN] ADD CONSTRAINT [FK_TGB銀行口座入出金TRN_TGB銀行口座F] FOREIGN KEY ( [システムCD], [演習CD], [銀行CD], [口座区分], [口座番号] ) REFERENCES [dbo].[TGB銀行口座F] ( [システムCD], [演習CD], [銀行CD], [口座区分], [口座番号] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGC保険契約F] ADD CONSTRAINT [FK_TGC保険契約F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGC出庫F] ADD CONSTRAINT [FK_TGC出庫F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGC寄託者台帳F] ADD CONSTRAINT [FK_TGC寄託者台帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGC運送契約F] ADD CONSTRAINT [FK_TGC運送契約F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TGK現金入出金TRN] ADD CONSTRAINT [FK_TGK現金入出金TRN_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSA仕入売上書類F] ADD CONSTRAINT [FK_TSA仕入売上書類F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSA仕入売上書類明細F] ADD CONSTRAINT [FK_TSA仕入売上書類明細F_TSA仕入売上書類F] FOREIGN KEY ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) REFERENCES [dbo].[TSA仕入売上書類F] ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSB銀行取引申込書類F] ADD CONSTRAINT [FK_TSB銀行取引申込書類F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSC運送書類F] ADD CONSTRAINT [FK_TSC運送書類F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSC運送書類明細F] ADD CONSTRAINT [FK_TSC運送書類明細F_TSC運送書類F] FOREIGN KEY ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) REFERENCES [dbo].[TSC運送書類F] ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSC運送費請求書F] ADD CONSTRAINT [FK_TSC運送費請求書F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSC運送費請求書手動F] ADD CONSTRAINT [FK_TSC運送費請求書手動F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSC運送費請求書手動明細F] ADD CONSTRAINT [FK_TSC運送費請求書手動明細F_TSC運送費請求書手動F] FOREIGN KEY ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) REFERENCES [dbo].[TSC運送費請求書手動F] ( [システムCD], [演習CD], [会社CD], [作成会社CD], [文書種類CD], [文書内容CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK伝票F] ADD CONSTRAINT [FK_TSK伝票F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK伝票仕入売上明細F] ADD CONSTRAINT [FK_TSK伝票仕入売上明細F_TSK伝票F] FOREIGN KEY ( [システムCD], [演習CD], [会社CD], [伝票区分], [伝票番号] ) REFERENCES [dbo].[TSK伝票F] ( [システムCD], [演習CD], [会社CD], [伝票区分], [伝票番号] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK伝票明細F] ADD CONSTRAINT [FK_TSK伝票明細F_TSK伝票F] FOREIGN KEY ( [システムCD], [演習CD], [会社CD], [伝票区分], [伝票番号] ) REFERENCES [dbo].[TSK伝票F] ( [システムCD], [演習CD], [会社CD], [伝票区分], [伝票番号] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK帳簿_仕訳日記帳F] ADD CONSTRAINT [FK_TSK帳簿_仕訳日記帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK帳簿_仕訳集計表F] ADD CONSTRAINT [FK_TSK帳簿_仕訳集計表F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK帳簿_八桁精算表F] ADD CONSTRAINT [FK_TSK帳簿_八桁精算表F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK帳簿_合計残高試算表F] ADD CONSTRAINT [FK_TSK帳簿_合計残高試算表F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK帳簿_損益計算書F] ADD CONSTRAINT [FK_TSK帳簿_損益計算書F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK帳簿_総勘定元帳F] ADD CONSTRAINT [FK_TSK帳簿_総勘定元帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK帳簿_貸借対照表F] ADD CONSTRAINT [FK_TSK帳簿_貸借対照表F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_仕入帳F] ADD CONSTRAINT [FK_TSK補助簿_仕入帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_受取手形記入帳F] ADD CONSTRAINT [FK_TSK補助簿_受取手形記入帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_商品有高帳F] ADD CONSTRAINT [FK_TSK補助簿_商品有高帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_売上帳F] ADD CONSTRAINT [FK_TSK補助簿_売上帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_売掛金元帳F] ADD CONSTRAINT [FK_TSK補助簿_売掛金元帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_当座預金出納帳F] ADD CONSTRAINT [FK_TSK補助簿_当座預金出納帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_支払手形記入帳F] ADD CONSTRAINT [FK_TSK補助簿_支払手形記入帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_現金出納帳F] ADD CONSTRAINT [FK_TSK補助簿_現金出納帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TSK補助簿_買掛金元帳F] ADD CONSTRAINT [FK_TSK補助簿_買掛金元帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTA損益計画F] ADD CONSTRAINT [FK_TTA損益計画F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTA社員台帳F] ADD CONSTRAINT [FK_TTA社員台帳F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTK摘要M] ADD CONSTRAINT [FK_TTK摘要M_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTK記帳チェックF] ADD CONSTRAINT [FK_TTK記帳チェックF_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTL合併残高F] ADD CONSTRAINT [FK_TTL合併残高F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTM名刺データ2F] ADD CONSTRAINT [FK_TTM名刺データ2F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTM名刺データF] ADD CONSTRAINT [FK_TTM名刺データF_TC1システムM] FOREIGN KEY ( [システムCD] ) REFERENCES [dbo].[TC1システムM] ( [システムCD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTXメールF] ADD CONSTRAINT [FK_TTXメールF_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO ALTER TABLE [dbo].[TTX文書F] ADD CONSTRAINT [FK_TTX文書F_TDA会社M] FOREIGN KEY ( [システムCD], [演習CD], [会社CD] ) REFERENCES [dbo].[TDA会社M] ( [システムCD], [演習CD], [会社CD] ) ON DELETE CASCADE ON UPDATE CASCADE GO