We create self referential foreign keys when we want to store hierarchical data in that table. A self referential foreign key column means that the column references itself like a snake swallowing its own tail.
Normally we self reference foreign keys in tables when we want to store data in hierarchical format. | ||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||