IF EXISTS (SELECT * FROM sysobjects
Where name = 'v_SalesView')
BEGIN
DROP VIEW [dbo].[v_SalesView]
END