IF (Exists(select Table_name from SysTable where LCase(Table_name)=LCase('v_New_StatisticsByCountry1'))) THEN
  Drop view v_New_StatisticsByCountry1
END IF

Go

Create View v_New_StatisticsByCountry1 as
Select Distinct 
  NewLodgings,
  DateReg,
  Room,
  Description
From v_New_StatisticsByCountry