Referential Integrity and triggers
From: Lisa Lewis <lewis_at_med.pitt.edu>
Date: 1998/06/12
Message-ID: <6lraip$34b$1_at_usenet01.srv.cis.pitt.edu>#1/1
Date: 1998/06/12
Message-ID: <6lraip$34b$1_at_usenet01.srv.cis.pitt.edu>#1/1
[Quoted] [Quoted] I have two tables A and B. I don't want a user to be able to insert a [Quoted] record into table A unless A.field1 is in B.field3. B.field3 is not a PK and is not even unique. Is my only option to use triggers? If A.field1 not [Quoted] exist in B.field3.....reject the insert. Will this be a big hit on performance?
Thanks
Lisa
Received on Fri Jun 12 1998 - 00:00:00 CEST