
/*------ ATD 401381 ------*/
IF NOT EXISTS 
(SELECT 1 FROM SYSCOLUMNS WHERE name = 'Unidade' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='ITVOLUMEPRODUTO')) 
ALTER TABLE ITVOLUMEPRODUTO ADD Unidade VARCHAR(3)
go

IF NOT EXISTS 
(SELECT 1 FROM SYSCOLUMNS WHERE name = 'Cean' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='ITNFENTCOMPLEMENTO')) 
ALTER TABLE ITNFENTCOMPLEMENTO ADD Cean VARCHAR(20)
go