ALTER TABLE FCM_LOCALCLI ADD NRCHECKLISTPADR NUMBER
/

CREATE INDEX FCM00056_FK ON FCM_LOCALCLI (NRCHECKLISTPADR ASC)
/

ALTER TABLE FCM_LOCALCLI 
  ADD CONSTRAINT FKFCM00056CHECKLIST_LOCALCLI FOREIGN KEY (NRCHECKLISTPADR)
      REFERENCES FCM_CHECKLIST (NRCHECKLIST)
/