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

Home -> Community -> Usenet -> c.d.o.server -> Re: not using foreign keys?

Re: not using foreign keys?

From: Martijn Tonies <m.tonies_at_upscene.removethis.com>
Date: Tue, 5 Jun 2007 11:40:58 +0200
Message-ID: <46652f78$0$30324$e4fe514c@dreader15.news.xs4all.nl>

> 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.

Tell your boss that the ONLY way to avoid get invalid data into your database is to have proper constraints.

It IS the way to go.

-- 
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Received on Tue Jun 05 2007 - 04:40:58 CDT

Original text of this message

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