Foreign key in DBMS: The Foreign key is a field or the set of fields in the relational database table, which points to the existing field in another table. It is a key that creates a relationship between the two tables. The main goal is to maintain the integrity of the relational data in the database relations. The foreign key acts as a cross-reference between the database tables because it references another table’s primary key in the same database.

We are describing the foreign key concept with the following example, so you can easily understand it.

This example contains two tables. The name of the first table is Teacher_Details, and the name of the second table is Course_Assign.

The first table contains three columns. The name of these columns is Teacher_ID, Teacher_Name, and Teacher_Age. In this table, Teacher_Id acts as a primary key.

The second table also contains the three columns. And, the name of three columns in the second table is Course_ID, Course_name, and Teacher_ID, where Teacher_ID is selected as a foreign key, which points to the primary key in the Teacher table. And, the Course_ID acts as a primary in the Course table. 

First Table: Teacher

Teacher_ID (Primary Key)Teacher_NameTeacher_Age
201Anuj22
202Anik24
203Manoj23
204Anuj24

Second Table: Course

Course_ID (Primary key)Course_NameTeacher_ID (Foreign Key)
401Math201
402C202
403Java201
404DBMS203
405Cloud Computing204
406Big Data202

Create the Foreign Key in RDBMS

We have learned the meaning of foreign key with its example. Now, we will discuss how to create a foreign key in the SQL table. So, we will take the above table to create the foreign key. In SQL, we can create the foreign key as shown below:

Using the following query, we can also create the foreign key constraint on the Teacher_ID column in the Course table when the table is already created.

Pin It on Pinterest

Share This