ALTER TABLE FCT_COMPSERVICO ADD IDUTILIZAREVENDA CHAR(1)
/

ALTER TABLE FCT_COMPSERVICO ADD CONSTRAINT CK_IDUTILIZAREVENDA CHECK (IDUTILIZAREVENDA IN ('S', 'N'))
/

UPDATE FCT_COMPSERVICO
  SET IDUTILIZAREVENDA = 'S'
WHERE IDUTILIZAREVENDA IS NULL
/