mssql drop view before creation

mssql-dropview-before-creation.sql

IF EXISTS (
  	SELECT TABLE_NAME
		FROM INFORMATION_SCHEMA.VIEWS
		WHERE TABLE_NAME = 'vw_Name'
		)
	DROP VIEW [vw_Name]
GO

CREATE VIEW [vw_Name]
AS
SELECT GETDATE() Today
GO