51asp.net_DB/医院管理系统实例程序.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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].[医生资料]
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].[门诊划价]') 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