
IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID(N'DBO.EST_PROD_TBL_DESC_PRC_FILIAL') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_PRC_FILIAL ADD QTDE_LIMIT_PROPZ INT NOT NULL DEFAULT 0;
END
GO


IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID(N'DBO.EST_PROD_TBL_DESC_QTDE_PRC_FILIAL') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_QTDE_PRC_FILIAL ADD QTDE_LIMIT_PROPZ INT NOT NULL DEFAULT 0;
END
GO

IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID(N'DBO.PDV_CAMPANHA_ADICIONAIS_EST_PROD_CAMPANHA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.PDV_CAMPANHA_ADICIONAIS_EST_PROD_CAMPANHA ADD QTDE_LIMIT_PROPZ INT NOT NULL DEFAULT 0;
END
GO


