IF NOT EXISTS (SELECT * FROM SYS.COLUMNS WHERE NAME = 'TP_LOGRA' AND OBJECT_ID = OBJECT_ID ('CHQ_EMI'))
BEGIN 
	ALTER TABLE DBO.CHQ_EMI ADD TP_LOGRA INT NULL;
	ALTER TABLE DBO.CHQ_EMI ADD	NR_END_EMI VARCHAR(15);
	ALTER TABLE DBO.CHQ_EMI ADD INSC_EST VARCHAR(20) NULL;
	ALTER TABLE DBO.CHQ_EMI ADD EMAIL VARCHAR(100);
	ALTER TABLE CHQ_EMI ADD CD_PAIS INT NULL;
END 