Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> not using foreign keys?
hello,
i have a question -- is the practice of using FKs to maintain referential integrity an argued (for/against) practice? im now on an enterprise banking project, and the db designer does not use FKs, he feels it creates a "closed system", and prefers to have the coders manage constraints via procs.
id never seen this before, but he said its an age-old argument (w/ merits) and one he adheres to. is this so, or is it an unusual personal preference?
i dont do much of the db work, but im just curious.
thanks
sm
Received on Mon Jun 04 2007 - 12:53:41 CDT