IF EXISTS
(
    SELECT 1
    FROM SYS.VIEWS
    WHERE NAME = 'V_EST_PROD_TBL_DESC_CARGO_TENTACLE'
)
    BEGIN
        DROP VIEW V_EST_PROD_TBL_DESC_CARGO_TENTACLE;
    END;
GO
CREATE VIEW V_EST_PROD_TBL_DESC_CARGO_TENTACLE
AS
     SELECT CD_EMP,
            CD_TBL_DESC_CARGO,
            DS_TBL_DESC_CARGO,
            CONVERT (DATE,DT_INI)as DT_INI,
            CONVERT (DATE,dateadd(year,2, getdate())) as DT_FIM,
            CD_USU,
            STS_TBL,
            GETDATE() AS DT_HR_CARGA
     FROM EST_PROD_TBL_DESC_CARGO;
	  