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
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
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
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
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
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
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
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_采購訂單明細_采購訂單
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

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

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

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