in Databases
382 views
0 votes
0 votes
Foreign key can not be used to refers to its own relation????
in Databases
382 views

4 Comments

No, foreign key even refers it's own relation too
0
0
How.  Can u give me example
0
0

lines from wiki

 the child and parent table may, in fact, be the same table, i.e. the foreign key refers back to the same table. Such a foreign key is known in SQL:2003 as a self-referencing or recursive foreign key. ... A table may have multiple foreign keys, and each foreign key can have a different parent table

0
0
Employee(eid,name,Mid), Mid is a F.K. reference eid of Employee

 

it is just like self-referential structures ( linked list ) in C language
0
0

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
1
Deepalitrapti asked in Databases Aug 19, 2018
300 views
Deepalitrapti asked in Databases Aug 19, 2018
300 views
0 votes
0 votes
0 answers
2
Deepalitrapti asked in Databases Aug 16, 2018
609 views
Deepalitrapti asked in Databases Aug 16, 2018
609 views
0 votes
0 votes
0 answers
4
srestha asked in Databases Sep 16, 2017
501 views
srestha asked in Databases Sep 16, 2017
by srestha
501 views