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_药品库存_药品资料 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_门诊划价明细_门诊划价 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_门诊挂号_门诊挂号类型 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].[医生资料]
上传时间: 2013-11-12
上传用户:sunshie
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_帐单明细_入住单 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_入住单_客房信息 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_客房信息_客房类型
上传时间: 2014-03-23
上传用户:chenhr
c#数据库开发实例:有很多的实例,对学习非常的有意义! 酒店管理系统源代码 医院信息管理系统源代码 图书馆管理系统源代码 财务管理系统源代码 生产管理系统源代码 人力资源管理实例程序源代码 进销存管理实例程序源代码 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 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-10-30
上传用户:392210346
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
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_分录表_凭证表 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 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 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 GO
上传时间: 2013-11-20
上传用户:清山绿水
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 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_图书罚款_图书信息 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 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 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_图书征订_图书信息 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
上传时间: 2014-05-04
上传用户:togetsomething
国外游戏开发者杂志2001年第八期配套代码,包含Tim Schoeder在Volition Red Faction使用到的碰撞探测系统源代码
上传时间: 2013-12-21
上传用户:蠢蠢66
周立功公司推广的一个小型实时嵌入式操作系统,适合在51或AVR等单片机上使用。压缩包里包括系统源代码和一个在51下移植的例子。在KEILC51下开发
上传时间: 2013-12-25
上传用户:netwolf
软件项目概要和详细设计标准模板和样例,其中包括通用的标准模板和一个政府网站系统的概要和详细设计样例,真正的软件项目开发文档,详细设计文档长达100多页很详细,大家可以下载参考。
上传时间: 2015-11-06
上传用户:watch100
JAVA设计模式visitor详解,电脑专卖系统源代码及详解!
上传时间: 2014-01-10
上传用户:shizhanincc