Really?
Duke Ganote, November 09, 2016 - 5:24 pm UTC
Academic exercise, or is there a real-world example when such a thing is necessary?
November 10, 2016 - 11:32 am UTC
True, valid use cases for circular FKs are rare. But they do exist. e.g. tables of cities and states.
Every city belongs to a state. Each state has a capital city. So both tables should reference each other!
Very useful
Rajendra kalepu, November 10, 2016 - 4:07 am UTC
Thank you very much Chris,
Its a good learning for me.
Regards,
Raj