IF EXISTS (SELECT * FROM SYSOBJECTS O, SYSUSERS U
           WHERE 
           O.NAME = 'FILILOJA' AND 
	   TYPE = 'V' 		  AND
	   U.UID = O.UID          AND 
	   U.NAME = USER)

   DROP VIEW FILILOJA
GO

CREATE VIEW FILILOJA AS
SELECT CDFILIAL+CDLOJA AS CDFILILOJA, 
       NMLOJA
FROM   LOJA
GO

-- VERSAO --
EXEC ATUVEROBJ 'FILILOJA','4.11.142';
GO

