Advanced Search

Add foreign key realtionship

/ Published in: Other
Save to your folder(s)
Add foreign key relationship

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.