
IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID(N'DBO.EST_PROD_TBL_DESC_EST_PROD') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_EST_PROD 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_EST_MC') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_EST_MC 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_EST_PROD_FABRIC') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_EST_PROD_FABRIC 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_EST_ARV_MERC_LINHA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_EST_ARV_MERC_LINHA 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_EST_ARV_MERC_CATEGORIA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_EST_ARV_MERC_CATEGORIA 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_EST_ARV_MERC_FAMILIA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_EST_ARV_MERC_FAMILIA 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_EST_ARV_MERC_LINHA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_QTDE_EST_ARV_MERC_LINHA 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_EST_ARV_MERC_CATEGORIA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_QTDE_EST_ARV_MERC_CATEGORIA 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_EST_PROD_FABRIC') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_QTDE_EST_PROD_FABRIC 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_EST_MC') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_QTDE_EST_MC 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_EST_ARV_MERC_FAMILIA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_QTDE_EST_ARV_MERC_FAMILIA 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_EST_PROD') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.EST_PROD_TBL_DESC_QTDE_EST_PROD 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') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.PDV_CAMPANHA_ADICIONAIS_EST_PROD 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_ARV_MERC_FAMILIA_CAMPANHA') AND NAME = 'QTDE_LIMIT_PROPZ')
BEGIN
	ALTER TABLE DBO.PDV_CAMPANHA_ADICIONAIS_EST_ARV_MERC_FAMILIA_CAMPANHA ADD QTDE_LIMIT_PROPZ INT NOT NULL DEFAULT 0;
END
GO

