• Post Reply Bookmark Topic Watch Topic
  • New Topic

Database Circular Reference

 
Susan
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

could somebody please explain what a database circular reference is, and what design shortcomings it has?

thanks,

Susan
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Table A has an FK to Table B. Table B has an FK to Table A. If I try to delete a record from Table A the delete will fail, because the record is referenced in Table B. If I try to delete a record from Table B the delete will fail because the record is referenced in Table A.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!