How to set Foreign key in oracle SQL Speed?

Asked

Viewed 928 times

1

inserir a descrição da imagem aqui

I am new using this program, as defined Foreign key in oracle SQL?

  • Right click on the table name and choose the options "Constraint > Add Foreign key"

1 answer

1


Right click on the table where you want to add FK, select the menu Constraint and then select Add Foreign Key.

inserir a descrição da imagem aqui In the window that opens, fill in the information:

  • Name: name of your FK
  • Column Name: is the column of your foreign key table
  • Reference Table Name: is the primary key table
  • Referencing Column: is the primary key of your reference table

inserir a descrição da imagem aqui

Click the button Apply


Reference:

Browser other questions tagged

You are not signed in. Login or sign up in order to post.