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].[醫生資料]