if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK手形顛末]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SPK手形顛末
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPKキャッシュフローOLD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SPKキャッシュフローOLD
GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SPM演習更新
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM記帳チェック挿入更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SPM記帳チェック挿入更新
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM記帳チェック挿入更新全部]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SPM記帳チェック挿入更新全部
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TC1システムM_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TC1システムM_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TC2演習M_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TC2演習M_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TC2演習M_演習CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TC2演習M_演習CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TC3学生グループM_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TC3学生グループM_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TC3学生グループM_学生グループCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TC3学生グループM_学生グループCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TDA会社M_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TDA会社M_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TDA会社M_演習CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TDA会社M_演習CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TDA会社M_会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TDA会社M_会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGA入出庫TRN_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGA入出庫TRN_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGA入出庫TRN_演習CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGA入出庫TRN_演習CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGA入出庫TRN_会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGA入出庫TRN_会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGA入出庫TRN_作成会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGA入出庫TRN_作成会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGA入出庫TRN_文書種類CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGA入出庫TRN_文書種類CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGA入出庫TRN_文書内容CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGA入出庫TRN_文書内容CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGB銀行口座F_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGB銀行口座F_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGB銀行口座F_演習CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGB銀行口座F_演習CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGB銀行口座F_銀行CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGB銀行口座F_銀行CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGB銀行口座F_口座区分_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGB銀行口座F_口座区分_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TGB銀行口座F_口座番号_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TGB銀行口座F_口座番号_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSA仕入売上書類F_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSA仕入売上書類F_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSA仕入売上書類F_演習CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSA仕入売上書類F_演習CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSA仕入売上書類F_会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSA仕入売上書類F_会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSA仕入売上書類F_作成会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSA仕入売上書類F_作成会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSA仕入売上書類F_文書種類CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSA仕入売上書類F_文書種類CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSA仕入売上書類F_文書内容CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSA仕入売上書類F_文書内容CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送書類F_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送書類F_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送書類F_演習CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送書類F_演習CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送書類F_会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送書類F_会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送書類F_作成会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送書類F_作成会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送書類F_文書種類CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送書類F_文書種類CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送書類F_文書内容CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送書類F_文書内容CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送費請求書手動F_作成会社CD_更新トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送費請求書手動F_作成会社CD_更新トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送費請求書手動F_文書種類CD_更新トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送費請求書手動F_文書種類CD_更新トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送費請求書手動F_文書内容CD_更新トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送費請求書手動F_文書内容CD_更新トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送費請求書手動F_システムCD_更新トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送費請求書手動F_システムCD_更新トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送費請求書手動F_演習CD_更新トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送費請求書手動F_演習CD_更新トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSC運送費請求書手動F_会社CD_更新トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSC運送費請求書手動F_会社CD_更新トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSK伝票F_システムCD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSK伝票F_システムCD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSK伝票F_演習CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSK伝票F_演習CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSK伝票F_会社CD_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSK伝票F_会社CD_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSK伝票F_伝票区分_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSK伝票F_伝票区分_削除トリガ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GTR_TSK伝票F_伝票番号_削除トリガ]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[GTR_TSK伝票F_伝票番号_削除トリガ]
GO


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



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TTM名刺データF_TDA会社M]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE dbo.TTM名刺データF DROP CONSTRAINT FK_TTM名刺データF_TDA会社M
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習登録]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SPM演習登録
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習登録.bak]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.[SPM演習登録.bak]
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 name FROM sysobjects WHERE (name = N'PK_TGB銀行入出金TRN') AND (xtype = 'PK'))
ALTER TABLE dbo.TGB銀行入出金TRN DROP CONSTRAINT PK_TGB銀行入出金TRN
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VK摘要F]') and OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW VK摘要F
GO