
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_EShopGoodsAttributes]') and xtype='V')
Drop view [dbo].[vw_EShopGoodsAttributes]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_EShopGroupAttributes]') and xtype='V')
Drop view [dbo].[vw_EShopGroupAttributes]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_EShopGoods]') and xtype='V')
Drop view [dbo].[vw_EShopGoods]



if exists (select * from dbo.sysobjects where id = object_id
(N'[dbo].[EShop_FactorIncrementalReduction]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[EShop_FactorIncrementalReduction]

if exists (select * from dbo.sysobjects where id = object_id
(N'[dbo].[EShop_FactorInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[EShop_FactorInsert]

if exists (select * from dbo.sysobjects where id = object_id
(N'[dbo].[EShop_FactorDetailInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[EShop_FactorDetailInsert]