
/*------ ATD 289787 ------*/
alter table itemprevia add prorrogacao integer
IF EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE NAME='prorrogacao' 
   and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='itemprevia')) 
   alter table itemprevia drop column prorrogacao
go
IF EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE NAME='prazopagamento' 
   and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='itemprevia')) 
   alter table itemprevia drop column prazopagamento
go
IF EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE NAME='bonificacao' 
   and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='itemprevia')) 
   alter table itemprevia drop column bonificacao
