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

GO

create view DBA.StoreNamesAudit
  as select H.Hotel_ID as HotelCode, --код,
    H.HotelName as HotelName, --наименование,
    null as HotelAddress, --местонахождение,
    "Date"(H.CreateDate) as HotelCreateDate, --Date(P.InsDateTime) - дата на първоначално конфигуриране в системата,
    "Date"(H.LastChanged) as HotelLastChangeDate, --дата на последна промяна,
    null as HotelDeactivatedDate --дата на деактивиране;
    from DBA.Hotels as H
//[v 18.12.2018]