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

GO

create view DBA.ItemsAudit
  as select S.ServiceNo as ItemCode, --код,
    S.ServiceName as ItemName, --наименование,
    "Date"(S.CreateDate) as ItemCreateDate, --дата на първоначално конфигуриране в системата,
    "Date"(S.LastChanged) as ItemLastChangeDate, --дата на последна промяна,
    null as ItemDeactivatedDate --дата на деактивиране;
    from DBA.Services as S
//[v 16.07.2019]