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訂貨合同計(jì)劃登記]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg5訂貨合同計(jì)劃登記]
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計(jì)算old]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mrp計(jì)算old]
GO

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1取得采購項(xiàng)]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1取得采購項(xiàng)]
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填生產(chǎn)訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj1填生產(chǎn)訂單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj2審生產(chǎn)訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj2審生產(chǎn)訂單]
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生成生產(chǎn)訂單]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5由MRP生成生產(chǎn)訂單]
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主生產(chǎn)計(jì)劃審核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生產(chǎn)計(jì)劃審核]
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps填需求計(jì)劃]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps填需求計(jì)劃]
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子項(xiàng)毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest子項(xiàng)毛需求]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest計(jì)算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest計(jì)算]
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子項(xiàng)毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp子項(xiàng)毛需求]
GO

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_加入進(jìn)銷存卡片]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_加入進(jìn)銷存卡片]
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商品庫存明細(xì)]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v商品庫存明細(xì)]
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資源負(fù)荷報表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v資源負(fù)荷報表]
GO

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jzh每月結(jié)轉(zhuǎn)日期表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jzh每月結(jié)轉(zhuǎn)日期表]
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發(fā)布時間]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp發(fā)布時間]
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簡單計(jì)算]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp簡單計(jì)算]
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].[臨時生產(chǎn)件資源負(fù)荷報表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[臨時生產(chǎn)件資源負(fù)荷報表]
GO

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[產(chǎn)品入庫單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[產(chǎn)品入庫單歷史]
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].[發(fā)布項(xiàng)清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[發(fā)布項(xiàng)清單]
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].[工藝線路細(xì)]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工藝線路細(xì)]
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].[權(quán)限登記]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[權(quán)限登記]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[標(biāo)準(zhǔn)工序]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[標(biāo)準(zhǔn)工序]
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].[物料狀態(tài)類別]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料狀態(tài)類別]
GO

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[系統(tǒng)日志]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[系統(tǒng)日志]
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].[計(jì)劃期參數(shù)]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[計(jì)劃期參數(shù)]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[計(jì)量單位]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[計(jì)量單位]
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].[訂貨合同發(fā)布]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[訂貨合同發(fā)布]
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].[調(diào)撥單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)