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

GO

create view DBA.OperationsAudit
  as select VS.N as OperationCode, --код,
    VS.SmetkaIme as OperationName, --наименование,
    "Date"(VS.CreateDate) as OperationCreateDate, --дата на първоначално конфигуриране в системата,
    "Date"(VS.LastChanged) as OperationChangeDate, --дата на последна промяна,
    null as OperationDeactivateDate --дата на деактивиране;
    from DBA.VidSmetki as VS
    where VS.N in( 1,2 ) 
//[v 18.12.2018]