Revisiting How to Avoid Referential Integrity Errors This is an off-site link.  Please review our Terms of Service for additional information.

(Chandra Sekhar Pathivada) Most of the time, DBAs need to deal with archiving, deleting, inserting, and masking data in relational tables. One major challenge that's common to all these activities is to mitigate the problems with references (i.e., foreign keys), where one table refers to other tables and the other tables, in turn, refer to many other tables as a hierarchy.

Read this article..

comments powered by Disqus