Re: Referential Integrity and triggers

How about constraints?

mars

vi.logistiek_at_wxs.nl

Lisa Lewis wrote in message <6lraip$34b$1_at_usenet01.srv.cis.pitt.edu>...
>I have two tables A and B. I don't want a user to be able to insert a
>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
>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