IF (EXISTS(Select * from sys.systable where LCase(table_name) = LCase('UserFilterAudit'))) THEN Drop view UserFilterAudit END IF GO create view DBA.UserFilterAudit as select A.AdminNo as UserKod, A.FullName as UserName from DBA.Admin as A //[v 18.12.2018]