IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS WHERE NAME ='LOTE_CAGREG' AND OBJECT_ID =OBJECT_ID('EST_NF_ENT_DANFE_PROVISORIO_ITENS'))
ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ITENS]
ADD [LOTE_CAGREG] varchar(30) NULL
GO