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].[進(jìn)貨單_供貨商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[進(jìn)貨單] DROP CONSTRAINT 進(jìn)貨單_供貨商_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)貨單歷史_供貨商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[進(jìn)貨單歷史] DROP CONSTRAINT 進(jìn)貨單歷史_供貨商_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[應(yīng)付款_供貨商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[應(yīng)付款] DROP CONSTRAINT 應(yīng)付款_供貨商_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[預(yù)付款_供貨商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[預(yù)付款] DROP CONSTRAINT 預(yù)付款_供貨商_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[預(yù)收款_供貨商_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[預(yù)收款] DROP CONSTRAINT 預(yù)收款_供貨商_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].[采購訂單明細(xì)_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[采購訂單明細(xì)] DROP CONSTRAINT 采購訂單明細(xì)_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采購訂單明細(xì)歷史_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[采購訂單明細(xì)歷史] DROP CONSTRAINT 采購訂單明細(xì)歷史_貨號_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].[調(diào)撥單_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[調(diào)撥單] DROP CONSTRAINT 調(diào)撥單_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[調(diào)撥單歷史_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[調(diào)撥單歷史] DROP CONSTRAINT 調(diào)撥單歷史_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[調(diào)貨申請_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[調(diào)貨申請] DROP CONSTRAINT 調(diào)貨申請_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)貨單明細(xì)_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[進(jìn)貨單明細(xì)] DROP CONSTRAINT 進(jìn)貨單明細(xì)_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)貨單明細(xì)歷史_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[進(jìn)貨單明細(xì)歷史] DROP CONSTRAINT 進(jìn)貨單明細(xì)歷史_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)銷存匯總表_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[進(jìn)銷存匯總表] DROP CONSTRAINT 進(jìn)銷存匯總表_貨號_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].[銷售單明細(xì)_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[銷售單明細(xì)] DROP CONSTRAINT 銷售單明細(xì)_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[銷售單明細(xì)歷史_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[銷售單明細(xì)歷史] DROP CONSTRAINT 銷售單明細(xì)歷史_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[銷售訂單明細(xì)_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[銷售訂單明細(xì)] DROP CONSTRAINT 銷售訂單明細(xì)_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[銷售訂單明細(xì)歷史_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[銷售訂單明細(xì)歷史] DROP CONSTRAINT 銷售訂單明細(xì)歷史_貨號_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].[應(yīng)付款_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[應(yīng)付款] DROP CONSTRAINT 應(yīng)付款_貨號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[應(yīng)收款_貨號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[應(yīng)收款] DROP CONSTRAINT 應(yīng)收款_貨號_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].[應(yīng)收款_客戶編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[應(yīng)收款] DROP CONSTRAINT 應(yīng)收款_客戶編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_進(jìn)貨單明細(xì)_進(jìn)貨單]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[進(jìn)貨單明細(xì)] DROP CONSTRAINT FK_進(jìn)貨單明細(xì)_進(jìn)貨單
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_銷售單明細(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_銷售訂單明細(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].[上下限對照表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[上下限對照表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[業(yè)務(wù)員清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[業(yè)務(wù)員清單]
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].[應(yīng)付款]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[應(yīng)付款]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[應(yīng)收款]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[應(yīng)收款]
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].[權(quán)限清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[權(quán)限清單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[每月結(jié)帳日期表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[每月結(jié)帳日期表]
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].[結(jié)帳歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[結(jié)帳歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[調(diào)撥單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[調(diào)撥單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[調(diào)撥單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[調(diào)撥單歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[調(diào)貨申請]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[調(diào)貨申請]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)價調(diào)整單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[進(jìn)價調(diào)整單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)貨單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[進(jìn)貨單]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)貨單歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[進(jìn)貨單歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)貨單明細(xì)]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[進(jìn)貨單明細(xì)]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)貨單明細(xì)歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[進(jìn)貨單明細(xì)歷史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[進(jìn)銷存匯總表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[進(jìn)銷存匯總表]
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].[采購訂單明細(xì)]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[采購訂單明細(xì)]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采購訂單明細(xì)歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[采購訂單明細(xì)歷史]
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].[銷售單明細(xì)]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[銷售單明細(xì)]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[銷售單明細(xì)歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[銷售單明細(xì)歷史]
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].[銷售訂單明細(xì)]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[銷售訂單明細(xì)]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[銷售訂單明細(xì)歷史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[銷售訂單明細(xì)歷史]
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].[預(yù)付款]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[預(yù)付款]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[預(yù)收款]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[預(yù)收款]
GO