Home / Questions / What do you mean by a self-referencing foreign key? Explain with the help of an example.
Explanatory Question

What do you mean by a self-referencing foreign key? Explain with the help of an example.

👁 2,238 Views
📘 Detailed Answer
🕒 Easy to Read
Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

Answer with Explanation

A foreign key that refers to its own relation is called self-referencing foreign key. It is also known as recursive foreign key. To understand the concept of self-referencing foreign key, consider the EMPLOYEE relation shown in Figure below. In this relation, EMP_NO is the primary key and the attribute MANAGER refers to EMP_NO and thus, is the self-referencing foreign key.