Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: not using foreign keys?
> 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.comReceived on Tue Jun 05 2007 - 04:40:58 CDT