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