Advanced Search

Agregar LLave Foránea

/ Published in: SQL
Save to your folder(s)
Agrega Llave Foránea

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. ALTER TABLE NOMBRETABLA1
  2.   ADD CONSTRAINT NOMBRERESTRICCION
  3.   FOREIGN KEY (CAMPOCLAVEFORANEA)
  4.   REFERENCES NOMBRETABLA2 (CAMPOCLAVEPRIMARIA);
  5.  
  6.  
  7. --Ejemplo--
  8.  
  9. ALTER TABLE TCliente
  10. ADD CONSTRAINT FK_TCliente_Ejecutivo
  11. FOREIGN KEY (IdEjecutivo)
  12. REFERENCES Ejecutivo (IdEjecutivo)

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.