ALTER TABLE LOGCATRACA ADD CDCONSUMIDOR VARCHAR(21)
/

INSERT INTO TABELA (IDCRIADOTAB, NMTABELABD, IDUTCALQTORC, IDATIVO)
    VALUES ('S', 'LOGCATRACA', 'N', 'S')
/

INSERT INTO COLUNA (NMCOLUNA, NMTABELABD, IDTIPOCOLUNA, NRTAMANHOCOL, IDCRIADOCOL, IDCOLUNANULL)
    VALUES ('CDCONSUMIDOR', 'LOGCATRACA', 'C', '21', 'S', 'N')
/

COMMIT
/ 