Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> not using foreign keys?

not using foreign keys?

From: <spacemarine_at_mailinator.com>
Date: Mon, 04 Jun 2007 10:53:41 -0700
Message-ID: <1180979621.128496.281540@n4g2000hsb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US