if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_藥品庫(kù)存_藥品資料]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[藥品庫(kù)存] DROP CONSTRAINT FK_藥品庫(kù)存_藥品資料
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_門(mén)診劃價(jià)明細(xì)_門(mén)診劃價(jià)]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[門(mén)診劃價(jià)明細(xì)] DROP CONSTRAINT FK_門(mén)診劃價(jià)明細(xì)_門(mén)診劃價(jià)
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_門(mén)診掛號(hào)_門(mén)診掛號(hào)類(lèi)型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[門(mén)診掛號(hào)] DROP CONSTRAINT FK_門(mén)診掛號(hào)_門(mén)診掛號(hào)類(lèi)型
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ī)生資料]