if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MRP物料需求計算_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[MRP物料需求計算] DROP CONSTRAINT MRP物料需求計算_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MRP物料需求計算結果_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[MRP物料需求計算結果] DROP CONSTRAINT MRP物料需求計算結果_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MRP物料需求歷史_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[MRP物料需求歷史] DROP CONSTRAINT MRP物料需求歷史_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清單_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[物料清單] DROP CONSTRAINT 物料清單_物料編號_fk
標簽：
生產管理
源代碼
上傳時間：
2013-11-23
上傳用戶：wcl168881111111
