if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg2審核采購訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg2審核采購訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg5訂貨合同計劃登記]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg5訂貨合同計劃登記]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采購訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采購訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采購訂單審核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采購訂單審核]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp計算old]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mrp計算old]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_KF2批次調撥單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_KF2批次調撥單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1刪除全部未用項]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1刪除全部未用項]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1取得采購項]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1取得采購項]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1填寫采購訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1填寫采購訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg3修改采購訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg3修改采購訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj1填生產訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj1填生產訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj2審生產訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj2審生產訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5填完工報告單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5填完工報告單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5由MRP生成生產訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5由MRP生成生產訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_kf1填成品入庫單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_kf1填成品入庫單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生產計劃審核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生產計劃審核]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生產計劃預排]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生產計劃預排]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps填需求計劃]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps填需求計劃]
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest子項毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest子項毛需求]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest計算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest計算]
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp子項毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp子項毛需求]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp生產件資源負荷]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp生產件資源負荷]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp計算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp計算]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp試算生產件資源負荷]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp試算生產件資源負荷]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_sc生成領料單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_sc生成領料單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_加入進銷存卡片]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_加入進銷存卡片]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sys生成資源日程表]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sys生成資源日程表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[低層碼]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[低層碼]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[V物料主文件]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V物料主文件]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v商品庫存明細]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v商品庫存明細]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v資源清單]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v資源清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v資源負荷報表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v資源負荷報表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bom信息狀態]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bom信息狀態]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bom狀態]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bom狀態]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jzh每月結轉日期表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jzh每月結轉日期表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp0]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrpcalcd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrpcalcd]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrpcalcm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrpcalcm]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp發布時間]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp發布時間]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp正式]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp正式]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp簡單計算]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp簡單計算]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp試算]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp試算]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[臨時生產件資源負荷報表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[臨時生產件資源負荷報表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[臨時資源負荷報表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[臨時資源負荷報表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[臨時進銷存卡片]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[臨時進銷存卡片]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生產計劃]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生產計劃]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生產計劃歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生產計劃歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生產計劃預排歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生產計劃預排歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主需求計劃]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主需求計劃]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主需求計劃歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主需求計劃歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[產品入庫單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[產品入庫單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[產品入庫單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[產品入庫單歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[功能模塊]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[功能模塊]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[發布項清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[發布項清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[完工報告單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[完工報告單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[完工報告單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[完工報告單歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[客戶修改歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客戶修改歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工作中心]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工作中心]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工廠日歷]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工廠日歷]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工藝線路主]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工藝線路主]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工藝線路細]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工藝線路細]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[庫存庫]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[庫存庫]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[報損報溢歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[報損報溢歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[換貨單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[換貨單歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[效期對照表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[效期對照表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[權限登記]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[權限登記]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[標準工序]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[標準工序]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料主文件]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料主文件]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料價值代碼]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料價值代碼]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料入庫單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料入庫單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料入庫單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料入庫單歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料反查表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料反查表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料展開表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料展開表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料歸屬類別]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料歸屬類別]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料狀態類別]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料狀態類別]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料計劃類別]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料計劃類別]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料需求計劃old]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料需求計劃old]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生產件資源負荷報表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生產件資源負荷報表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生產大綱]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生產大綱]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生產大綱歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生產大綱歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生產訂單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生產訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生產訂單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生產訂單歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生產訂單審核]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生產訂單審核]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[系統日志]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[系統日志]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職工清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職工清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[計劃期參數]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[計劃期參數]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[計量單位]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[計量單位]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[訂貨合同]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[訂貨合同]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[訂貨合同發布]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[訂貨合同發布]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[訂貨合同接收]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[訂貨合同接收]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[詞庫]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[詞庫]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[調撥單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)