if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0アクセスログログインID一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP0アクセスログログインID一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0アクセスログ一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP0アクセスログ一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0アクセスログ更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP0アクセスログ更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP0伝票採番取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP0伝票採番取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類入出金フラグ適用]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類入出金フラグ適用] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類挿入2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類挿入2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類発信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類発信] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類発信2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類発信2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類返信取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類返信取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類返信済みフラグ適用]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類返信済みフラグ適用] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行取引書類開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行取引書類開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座一覧2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座一覧3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座一覧3] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座一覧4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座一覧4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金一覧2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金通帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金通帳挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座入出金通帳更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座入出金通帳更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPB銀行口座挿入銀行自社別段]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPB銀行口座挿入銀行自社別段] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC保険一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC保険一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC保険削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC保険削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC保険取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC保険取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC保険更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC保険更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC出庫一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC出庫一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC出庫削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC出庫削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC出庫取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC出庫取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC出庫更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC出庫更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC寄託一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC寄託一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC寄託入庫更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC寄託入庫更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC寄託出庫数更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC寄託出庫数更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC寄託削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC寄託削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC寄託取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC寄託取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC寄託受付]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC寄託受付] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC寄託更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC寄託更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送受信書類削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送受信書類削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送契約一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送契約一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送契約削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送契約削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送契約取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送契約取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送契約更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送契約更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送書類一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送書類一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送書類削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送書類削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送書類取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送書類取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送書類挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送書類挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送書類更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送書類更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送書類発信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送書類発信] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送書類開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送書類開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求先一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求先一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求先未請求一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求先未請求一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書手動一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書手動一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書手動削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書手動削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書手動取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書手動取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書手動挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書手動挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書手動更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書手動更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書手動発信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書手動発信] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書発信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書発信] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPC運送費請求書開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPC運送費請求書開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類一覧2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類一覧3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類一覧3] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類一覧4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類一覧4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類取得4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類取得4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類取得台帳突合]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類取得台帳突合] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類挿入2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類挿入2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類挿入4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類挿入4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類更新2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類更新2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類更新4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類更新4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類発信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類発信] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類発信2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類発信2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類発信4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類発信4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類返信済みフラグ適用]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類返信済みフラグ適用] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD仕入売上書類開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD仕入売上書類開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫一覧4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫一覧4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫一覧9]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫一覧9] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫取得2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫取得2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫取得4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫取得4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫受付]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫受付] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫受付4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫受付4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫挿入2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫挿入2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫挿入3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫挿入3] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫挿入4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫挿入4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫挿入4dummy]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫挿入4dummy] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫更新2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫更新2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫更新3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫更新3] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫更新4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫更新4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫書類開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫書類開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫書類開封2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫書類開封2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫発信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫発信] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫発信2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫発信2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫発信3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫発信3] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫発信4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫発信4] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD入出庫非受付]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD入出庫非受付] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD在庫チェック]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD在庫チェック] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託依頼取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託依頼取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託依頼受付]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託依頼受付] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託依頼挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託依頼挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託依頼更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託依頼更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託依頼発信]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託依頼発信] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託入庫一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託入庫一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託入庫取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託入庫取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託出庫依頼書挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託出庫依頼書挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託商品明細一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託商品明細一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託商品明細取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託商品明細取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託商品明細更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託商品明細更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託在庫挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託在庫挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託在庫挿入2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託在庫挿入2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託在庫繰越商品削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託在庫繰越商品削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託在庫繰越商品挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託在庫繰越商品挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託在庫繰越商品更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託在庫繰越商品更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託書類開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託書類開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託確認文書挿入倉庫]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託確認文書挿入倉庫] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託確認文書挿入管理部]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託確認文書挿入管理部] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD寄託確認文書開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD寄託確認文書開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD材料出庫挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD材料出庫挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD材料出庫更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD材料出庫更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD製造指図書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD製造指図書一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD製造指図書削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD製造指図書削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD製造指図書取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD製造指図書取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD製造指図書挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD製造指図書挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPD製造指図書更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPD製造指図書更新] GO 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仕入明細取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK仕入明細取得] GO 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伝票_仕入伝票取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_仕入伝票取得] GO 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伝票_仕入伝票更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_仕入伝票更新] GO 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伝票_仕入明細取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_仕入明細取得] GO 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伝票_入金伝票一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_入金伝票一覧] GO 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伝票_入金伝票挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_入金伝票挿入] GO 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伝票_出金伝票一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_出金伝票一覧] GO 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伝票_出金伝票挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_出金伝票挿入] GO 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伝票_削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_削除] GO 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伝票_売上伝票取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_売上伝票取得] GO 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伝票_売上伝票更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_売上伝票更新] GO 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伝票_売上明細取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_売上明細取得] GO 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伝票_振替伝票取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_振替伝票取得] GO 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伝票_振替伝票更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_振替伝票更新] GO 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伝票_材料仕入伝票取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_材料仕入伝票取得] GO 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伝票_材料仕入伝票更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_材料仕入伝票更新] GO 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伝票_製造部振替伝票一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票_製造部振替伝票一覧] GO 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伝票次番号]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK伝票次番号] GO 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勘定残高データ取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK勘定残高データ取得] GO 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契約書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK契約書一覧] GO 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契約書取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK契約書取得] GO 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契約書挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK契約書挿入] GO 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契約書開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK契約書開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売M取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売M取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売M更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売M更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売TRN削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売TRN削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売TTL削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売TTL削除] GO 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小売販売一覧取得_先生ORG]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売一覧取得_先生ORG] GO 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小売販売一覧取得_生徒ORG]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売一覧取得_生徒ORG] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売出荷FON]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売出荷FON] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売削除FON]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売削除FON] GO 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小売販売取得_明細]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売取得_明細] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売更新_TRN]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売更新_TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売更新_TTL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売更新_TTL] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売買上票印刷FON]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売買上票印刷FON] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売返品_TRN]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売返品_TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売返品_TTL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売返品_TTL] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売販売領収書印刷FON]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売販売領収書印刷FON] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK小売返品更新1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK小売返品更新1] GO 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帳簿_仕訳帳取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳帳取得] GO 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帳簿_仕訳帳取得伝票貸方]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳帳取得伝票貸方] GO 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帳簿_仕訳帳挿入_振替伝票]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳帳挿入_振替伝票] GO 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帳簿_仕訳帳更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳帳更新] GO 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帳簿_仕訳日記帳取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳日記帳取得] GO 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帳簿_仕訳日記帳更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳日記帳更新] GO 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帳簿_仕訳集計表取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳集計表取得] GO 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帳簿_仕訳集計表更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_仕訳集計表更新] GO 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帳簿_八桁精算表挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_八桁精算表挿入] GO 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帳簿_合計残高試算表取引日一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_合計残高試算表取引日一覧] GO 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帳簿_合計残高試算表取得日付指定]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_合計残高試算表取得日付指定] GO 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帳簿_合計残高試算表更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_合計残高試算表更新] GO 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帳簿_損益計算書取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_損益計算書取得] GO 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帳簿_損益計算書更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_損益計算書更新] GO 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帳簿_株主資本等変動計算書取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_株主資本等変動計算書取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK帳簿_株主資本等変動計算書取得M]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_株主資本等変動計算書取得M] GO 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帳簿_株主資本等変動計算書更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_株主資本等変動計算書更新] GO 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帳簿_総勘定元帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_総勘定元帳挿入] GO 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帳簿_貸借対照表取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_貸借対照表取得] GO 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帳簿_貸借対照表更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK帳簿_貸借対照表更新] GO 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手形削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK手形削除] GO 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手形取得裏書]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK手形取得裏書] GO 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手形更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK手形更新] GO 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手形返却]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK手形返却] GO 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手形顛末済一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK手形顛末済一覧] GO 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演習手形一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK演習手形一覧] GO 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現金入出金削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK現金入出金削除] GO 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現金入出金履歴一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK現金入出金履歴一覧] GO 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現金入出金日集計]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK現金入出金日集計] GO 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現金入出金残高]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK現金入出金残高] GO 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社員台帳一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK社員台帳一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK社員台帳一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK社員台帳一覧2] GO 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社員台帳取得2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK社員台帳取得2] GO 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社員台帳更新2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK社員台帳更新2] GO 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社員台帳更新_離職]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK社員台帳更新_離職] GO 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精算表修正仕訳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK精算表修正仕訳挿入] GO 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給与明細一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK給与明細一覧] GO 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給与明細取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK給与明細取得] GO 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給与明細社員一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK給与明細社員一覧] GO 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繰越商品挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK繰越商品挿入] GO 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繰越残高設定挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK繰越残高設定挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK繰越残高設定挿入10]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK繰越残高設定挿入10] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK繰越残高設定挿入5]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK繰越残高設定挿入5] GO 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自動転記帳簿_仕訳帳勘定科目照会]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK自動転記帳簿_仕訳帳勘定科目照会] GO 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自動転記帳簿_仕訳帳照会]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK自動転記帳簿_仕訳帳照会] GO 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自動転記帳簿_仕訳集計表照会]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK自動転記帳簿_仕訳集計表照会] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPK自動転記帳簿_仕訳集計表照会FromTo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK自動転記帳簿_仕訳集計表照会FromTo] GO 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自動転記帳簿_合計残高試算表照会]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK自動転記帳簿_合計残高試算表照会] GO 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自動転記帳簿_総勘定元帳照会]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK自動転記帳簿_総勘定元帳照会] GO 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自動転記帳簿_財務諸表2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK自動転記帳簿_財務諸表2] GO 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補助簿_仕入帳取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_仕入帳取得] GO 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補助簿_仕入帳更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_仕入帳更新] GO 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補助簿_受取手形記入帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_受取手形記入帳挿入] GO 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補助簿_商品有高帳取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_商品有高帳取得] GO 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補助簿_商品有高帳更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_商品有高帳更新] GO 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補助簿_売上帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_売上帳挿入] GO 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補助簿_売掛金元帳取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_売掛金元帳取得] GO 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補助簿_売掛金元帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_売掛金元帳挿入] GO 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補助簿_当座預金出納帳取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_当座預金出納帳取得] GO 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補助簿_当座預金出納帳更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_当座預金出納帳更新] GO 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補助簿_支払手形記入帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_支払手形記入帳挿入] GO 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補助簿_期首残高削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_期首残高削除] GO 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補助簿_期首残高挿入売掛金元帳]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_期首残高挿入売掛金元帳] GO 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補助簿_期首残高挿入買掛金元帳]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_期首残高挿入買掛金元帳] GO 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補助簿_現金出納帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_現金出納帳挿入] GO 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補助簿_買掛金元帳取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_買掛金元帳取得] GO 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補助簿_買掛金元帳挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK補助簿_買掛金元帳挿入] GO 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領収書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK領収書一覧] GO 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領収書取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK領収書取得] GO 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領収書更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK領収書更新] GO 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領収書開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPK領収書開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL_分析情報取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL_分析情報取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL合併残高F_削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL合併残高F_削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL合併残高F_登録]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL合併残高F_登録] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL合併残高情報取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL合併残高情報取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL合併精算表挿入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL合併精算表挿入] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL合併精算表更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL合併精算表更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL合併財務諸表]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL合併財務諸表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL合併財務諸表2区分]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL合併財務諸表2区分] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL損益分岐点取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL損益分岐点取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPL残高取得_SJ合計残高試算表及び整理記入]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPL残高取得_SJ合計残高試算表及び整理記入] 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].[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].[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].[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].[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].[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].[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].[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会社一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM会社一覧2] 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会社全部一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM会社全部一覧2] 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会社削除OLD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM会社削除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会社市場一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM会社市場一覧2] 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].[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].[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].[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].[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勘定科目更新2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM勘定科目更新2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM勘定科目更新3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM勘定科目更新3] 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].[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].[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勘定科目詳細取得2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM勘定科目詳細取得2] 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].[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商品一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM商品一覧2] 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].[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商品市場一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM商品市場一覧2] 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].[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].[SPM寄託会社取得2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM寄託会社取得2] 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].[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].[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].[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].[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材料一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM材料一覧2] 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].[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].[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].[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演習_参加ユーザー一覧2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習_参加ユーザー一覧2] 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].[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].[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].[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].[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演習更新0]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習更新0] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習更新1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習更新1] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習更新2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習更新2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習更新22]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習更新22] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習更新2old]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習更新2old] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習更新3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習更新3] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPM演習更新4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習更新4] 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].[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].[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演習登録1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM演習登録1] 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].[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].[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記帳チェックOLD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM記帳チェック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記帳チェック一覧OLD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM記帳チェック一覧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].[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].[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].[SPM記帳チェック挿入現物預金2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM記帳チェック挿入現物預金2] 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].[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].[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].[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].[SPM部品展開表材料一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPM部品展開表材料一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNFAX一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNFAX一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNFAX作成]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNFAX作成] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNFAX削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNFAX削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNFAX取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNFAX取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNFAX開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNFAX開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール作成]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール作成] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール作成2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール作成2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール受信一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール受信一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール送信一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール送信一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール開封]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール開封] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPNメール開封2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPNメール開封2] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN受信文書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN受信文書一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN受発信文書削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN受発信文書削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN学生メール受信一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN学生メール受信一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN学生メール送信一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN学生メール送信一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN学生受信文書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN学生受信文書一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN学生発信文書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN学生発信文書一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN文書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN文書一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPN発信文書一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPN発信文書一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPPポータル会社取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPPポータル会社取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPPポータル会社更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPPポータル会社更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPPポータル商品再採番]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPPポータル商品再採番] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPPポータル商品削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPPポータル商品削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPPポータル商品取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPPポータル商品取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPPポータル商品更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPPポータル商品更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPPポータル商品表示順更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPPポータル商品表示順更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR仕入売上実績]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR仕入売上実績] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR他社在庫一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR他社在庫一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR入出庫在庫]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR入出庫在庫] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR入出庫在庫会計期間内]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR入出庫在庫会計期間内] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR入出庫在庫単価]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR入出庫在庫単価] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR入出庫在庫明細]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR入出庫在庫明細] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR入出庫在庫明細仕入売上伝票]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR入出庫在庫明細仕入売上伝票] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR分析_収益性情報取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR分析_収益性情報取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR分析_損益実績取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR分析_損益実績取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR分析_損益計画取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR分析_損益計画取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR分析_損益計画更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR分析_損益計画更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR文書番号一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR文書番号一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR文書種類一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR文書種類一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR書類集計一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR書類集計一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR材料入出庫在庫]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR材料入出庫在庫] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR材料入出庫在庫会計期間内]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR材料入出庫在庫会計期間内] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR材料入出庫在庫単価]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR材料入出庫在庫単価] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR製品入出庫在庫]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR製品入出庫在庫] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPR製品入出庫在庫会計期間内]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPR製品入出庫在庫会計期間内] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPT名刺デザイン一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPT名刺デザイン一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPT名刺データ2取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPT名刺データ2取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPT名刺データ2更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPT名刺データ2更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPT名刺データ取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPT名刺データ取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPT名刺データ更新]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPT名刺データ更新] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV区分情報一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV区分情報一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV演習メール拒否削除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV演習メール拒否削除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV演習メール拒否登録]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV演習メール拒否登録] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV演習履歴取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV演習履歴取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV演習履歴登録]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV演習履歴登録] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV自社情報取得]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV自社情報取得] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV選択可能会社一覧]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV選択可能会社一覧] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV選択可能会社選択解除]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV選択可能会社選択解除] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV選択可能会社選択解除会社]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV選択可能会社選択解除会社] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPV選択可能会社選択解除生徒]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SPV選択可能会社選択解除生徒] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VVK摘要F]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[VVK摘要F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC0アクセスログ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC0アクセスログ] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC0ウェイトフラグ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC0ウェイトフラグ] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC1システムM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC1システムM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC2演習M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC2演習M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC3学生グループM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC3学生グループM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC4演習許可学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC4演習許可学生M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC4演習許可学生グループM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC4演習許可学生グループM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC5学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC5学生M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC6演習履歴M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC6演習履歴M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC9区分M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC9区分M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC9名刺デザインM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC9名刺デザインM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TC9文書種類M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TC9文書種類M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA会社M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA会社M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA勘定科目M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA勘定科目M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA勘定科目会社学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA勘定科目会社学生M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA商品M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA商品M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA報告書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA報告書書式M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA市場M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA市場M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA材料M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA材料M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA株主資本等変動計算書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA株主資本等変動計算書書式M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA表記名称M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA表記名称M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA部品展開M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TDA部品展開M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA入出庫TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGA入出庫TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA入出庫明細TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGA入出庫明細TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA契約書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGA契約書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA手形F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGA手形F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGA手形明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGA手形明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGB銀行口座F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGB銀行口座F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGB銀行口座入出金TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGB銀行口座入出金TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC保険契約F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC保険契約F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC出庫F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC出庫F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託在庫F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC寄託在庫F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託在庫明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC寄託在庫明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託者TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC寄託者TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託者台帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC寄託者台帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC寄託者明細TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC寄託者明細TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGC運送契約F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGC運送契約F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGD製造指図書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGD製造指図書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGK現金入出金TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGK現金入出金TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGPポータル会社F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGPポータル会社F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGPポータル商品F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TGPポータル商品F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TKH小売販売M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TKH小売販売M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TKH小売販売TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TKH小売販売TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TKH小売販売TTL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TKH小売販売TTL] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSA仕入売上書類F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSA仕入売上書類F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSA仕入売上書類明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSA仕入売上書類明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSA領収書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSA領収書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSB銀行取引申込書類F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSB銀行取引申込書類F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送書類F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSC運送書類F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送書類明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSC運送書類明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送費請求書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSC運送費請求書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送費請求書手動F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSC運送費請求書手動F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSC運送費請求書手動明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSC運送費請求書手動明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK伝票F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK伝票F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK伝票仕入売上明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK伝票仕入売上明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK伝票明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK伝票明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_仕訳帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_仕訳帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_仕訳日記帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_仕訳日記帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_仕訳集計表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_仕訳集計表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_八桁精算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_八桁精算表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_合計残高試算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_合計残高試算表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_損益計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_損益計算書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_株主資本等変動計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_株主資本等変動計算書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_株主資本等変動計算書FM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_株主資本等変動計算書FM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_総勘定元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_総勘定元帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK帳簿_貸借対照表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK帳簿_貸借対照表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_仕入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_仕入帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_受取手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_受取手形記入帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_商品有高帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_商品有高帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_売上帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_売上帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_売掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_売掛金元帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_当座預金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_当座預金出納帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_支払手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_支払手形記入帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_現金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_現金出納帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TSK補助簿_買掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TSK補助簿_買掛金元帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA損益計画F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTA損益計画F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA社員台帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTA社員台帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA社員台帳M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTA社員台帳M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA給与明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTA給与明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTK摘要M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTK摘要M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTK記帳チェックF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTK記帳チェックF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTL合併残高F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTL合併残高F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTM名刺データ2F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTM名刺データ2F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTM名刺データF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTM名刺データF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTXFAXF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTXFAXF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTXメールF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTXメールF] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTX文書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TTX文書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TC4演習許可学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TC4演習許可学生M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TC4演習許可学生グループM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TC4演習許可学生グループM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TC5学生M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TC5学生M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA報告書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TDA報告書書式M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA株主資本等変動計算書書式M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TDA株主資本等変動計算書書式M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA部品展開M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TDA部品展開M] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGA入出庫明細TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TGA入出庫明細TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGB銀行口座入出金TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TGB銀行口座入出金TRN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGC寄託在庫明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TGC寄託在庫明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK伝票仕入売上明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK伝票仕入売上明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK伝票明細F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK伝票明細F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_仕訳帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_仕訳帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_仕訳日記帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_仕訳日記帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_仕訳集計表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_仕訳集計表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_八桁精算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_八桁精算表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_合計残高試算表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_合計残高試算表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_損益計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_損益計算書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_株主資本等変動計算書F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_株主資本等変動計算書F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_総勘定元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_総勘定元帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK帳簿_貸借対照表F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK帳簿_貸借対照表F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_仕入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_仕入帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_受取手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_受取手形記入帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_商品有高帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_商品有高帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_売上帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_売上帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_売掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_売掛金元帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_当座預金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_当座預金出納帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_支払手形記入帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_支払手形記入帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_現金出納帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_現金出納帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK補助簿_買掛金元帳F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TSK補助簿_買掛金元帳F] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TTL合併残高F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[YTMP_TTL合併残高F] GO