Posted By

ironcrema on 10/27/16


Tagged


Versions (?)

Add foreign key realtionship


 / Published in: Other
 

Add foreign key relationship

  1. ALTER TABLE `empleado`
  2. ADD CONSTRAINT `fk_Empleado_Ubigeo` FOREIGN KEY (`CodigoUbigeo`) REFERENCES `ubigeo` (`CodigoUbigeo`) ON DELETE CASCADE ON UPDATE CASCADE;
  3.  
  4. ALTER TABLE `empleado`
  5. ADD CONSTRAINT `fk_Empleado_Ubigeo` FOREIGN KEY (`CodigoUbigeo`) REFERENCES `ubigeo` (`CodigoUbigeo`) ;

Report this snippet  

You need to login to post a comment.