if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計(jì)算_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計(jì)算] DROP CONSTRAINT mrp物料需求計(jì)算_物料編號(hào)_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計(jì)算結(jié)果_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計(jì)算結(jié)果] DROP CONSTRAINT mrp物料需求計(jì)算結(jié)果_物料編號(hào)_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求歷史_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求歷史] DROP CONSTRAINT mrp物料需求歷史_物料編號(hào)_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清單_物料編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[物料清單] DROP CONSTRAINT 物料清單_物料編號(hào)_fk