ALTER TABLE COMPROPER
    DROP CONSTRAINT FKCMP00295COMPRADO
/    

ALTER TABLE COMPROPER
    ADD CONSTRAINT FKCMP00295COMPRADO FOREIGN KEY  (CDCOMPRADOR)
       REFERENCES COMPRADOR (CDOPERADOR) ON DELETE CASCADE
/