Re: Primary key and Foreign key

From: K.Y. Fung <kyfung_at_hotmail.com>
Date: 18 Sep 2002 18:37:22 -0700
Message-ID: <c22bb40d.0209181737.2957acb0@posting.google.com>

Heinz Huber <hhuber_at_racon-linz.at> wrote in message news:<Xns928B56719740Bhhuberraconlinzat_at_195.3.96.116>...
> kyfung_at_hotmail.com (K.Y. Fung) wrote in
> news:c22bb40d.0209142326.2dd7ca_at_posting.google.com:
> To cut the whole story short, you can't do what you want with constraint or
> fk definitions alone. You have to have some way of disabling a delete on a
> table.
>
> Regards,
> Heinz

Thanks everybody, I have just send my homework to my tutor. If you guys are interested in the "model answer" (and I am very sure there are more than just 1 correct answer), let us wait for 2 weeks and I shall post a summary for further discussion.

Regards,
K.Y. Fung Received on Wed Sep 18 2002 - 20:37:22 CDT