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