0 votes 0 votes Foreign key can not be used to refers to its own relation???? Deepalitrapti asked Aug 16, 2018 Deepalitrapti 387 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply srestha commented Aug 16, 2018 reply Follow Share No, foreign key even refers it's own relation too 0 votes 0 votes Deepalitrapti commented Aug 16, 2018 reply Follow Share How. Can u give me example 0 votes 0 votes srestha commented Aug 16, 2018 reply Follow Share 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 votes 0 votes Shaik Masthan commented Aug 16, 2018 reply Follow Share 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 votes 0 votes Please log in or register to add a comment.
