From: ynp@phantom.com (Youri Podchosov)
Newsgroups: comp.databases.oracle
Subject: FOREIGN KEY constraint
Date: 26 Apr 1994 10:46:49 GMT
Organization: [MindVox] / Phantom Access Technologies / (+1 800-MindVox)
Lines: 13
Message-ID: <2pirep$e6c@dockmaster.phantom.com>
NNTP-Posting-Host: mindvox.phantom.com
X-Newsreader: TIN [version 1.2 PL2]


Does anybody have anything to say about table/column level constraint 
FOREIGN KEY?  Any warnings/observations/cautions?  How does it compare to 
database triggers used for the same purpose?

The reason for these questions is: we're gonna redefine (I mean ALTER) 
the most part of legacy database to enforce referential integrity by 
means of ORACLE itself, so although I personally don't see any reasonable
objections to such a modification, not everybody is 100% sure about it.

Thank you in advance for your time.

___
YNP