ALTER TABLE EXECUCAOPESQ ADD (
  NRPROGRAMACAOPESQ NUMBER(10) NOT NULL
)
/
ALTER TABLE EXECUCAOPESQ ADD CONSTRAINT FKMYM00021PROGRAMACAOPESQ FOREIGN KEY (NRPROGRAMACAOPESQ, NRORG) REFERENCES PROGRAMACAOPESQ (NRPROGRAMACAOPESQ, NRORG)
/
CREATE INDEX FKMYM00021PROGRAMACAOPESQ ON EXECUCAOPESQ (NRPROGRAMACAOPESQ, NRORG)