IF NOT EXISTS (SELECT *FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PDV_VD_IT_REC' AND COLUMN_NAME = 'TP_CAPT_RECEITA')
BEGIN 
	ALTER TABLE PDV_VD_IT_REC ADD TP_CAPT_RECEITA VARCHAR(1) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS
END 