if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tu_EShopTrackingDetail]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
Drop Trigger [dbo].[Tu_EShopTrackingDetail]

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].[vw_EshopTracking]') and xtype='V ')
Drop view [dbo].[vw_EshopTracking]

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Sp_SodorFactor_Retail]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Sp_SodorFactor_Retail]


IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Sp_OnlineProductTracking]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Sp_OnlineProductTracking]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TI_Over_Under_Factor]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
Drop Trigger [dbo].[TI_Over_Under_Factor]


IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Club_Charge]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Club_Charge]









