
/*------ ATD 470240 ------*/
-- Adicionando coluna QuantEncomenda na tabela ItemPrevia
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'QuantEncomenda' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='ItemPrevia')) 
ALTER TABLE ItemPrevia ADD QuantEncomenda DECIMAL(13,3)
go