醫(yī)院信息管理系統(tǒng)源代碼

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_門診劃價明細(xì)_門診劃價]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[門診劃價明細(xì)] DROP CONSTRAINT FK_門診劃價明細(xì)_門診劃價
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].[產(chǎn)地]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[產(chǎn)地]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[醫(yī)生資料]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[醫(yī)生資料]