IF NOT EXISTS (	SELECT *FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PDV_VD'AND COLUMN_NAME = 'NM_COMPRADOR' ) 

BEGIN 
ALTER TABLE PDV_VD ADD NM_COMPRADOR VARCHAR(100) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS
END;