IF (EXISTS(Select * from sys.systable where LCase(table_name) = LCase('StoreFilterAudit')))
THEN Drop view StoreFilterAudit
END IF

GO

create view DBA.StoreFilterAudit
  as select H.Hotel_ID as StoreN,
    H.HotelName as StoreName
    from DBA.Hotels as H
//[v 18.12.2018]