
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PDV_VD_IT_REC' AND COLUMN_NAME ='NM_MEDICO')
BEGIN 
	ALTER TABLE PDV_VD_IT_REC ADD NM_MEDICO VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS CONSTRAINT DF_PDV_VD_IT_REC_NM_MEDICO DEFAULT '';
END 