Cacher is the code snippet organizer for pro developers

IF EXISTS(SELECT * FROM sys.views WHERE name = 'e_note' AND schema_id = SCHEMA_ID('dbo'))
  DROP VIEW dbo.e_note
GO