How to create MySQL foreign key between two tables?

Learn how to create a foreign key (FK) between two MySQL tables using Devart's visual editor - dbForge Studio for MySQL
Learn more: http://www.devart.com/dbforge/mysql/studio/

---

Closed Caption:


Welcome to the dbForge Studio for MySQL
tutorial.
In this tutorial we will review creating a foreign
key between two tables
with the functionality of Devart's MySQL
Manager.
The process of creating a foreign key
is quite simple.
Let's assume that we have two tables


and we need to link them through a key field.
Herewith, there is no relationship between the
tables yet.

To create a foreign key, in the popup menu Constraints of the child table,
you can select the New Foreign Key command
or open a table editor
and select the Constraints tab.

Where in the popup menu
select the New Foreign Key command.

The dialog will open where we can select the
table
that we will be referring to.

Let's specify what columns will be used for a
relation.
Herewith, data types between the columns must
be identical.
On the Advanced tab you can specify
the additional properties of a foreign key.

Press OK.

The DDL of the table has been refreshed.

Save our changes.

A foreign key has been successfully created.

Your have been watching the dbForge Studio for
MySQL tutorual.
Feel free to get all the benefits using the Most
Intellegent MySQL GUI Tool by Devart.
Thank you for your time.