Subject | FK's and NULL |
---|---|
Author | Daniel Jimenez |
Post date | 2004-10-26T22:09:56Z |
Hi,
This is a question for Helen, as I have been reading her Book, and I am not
sure I understand the following statement:
"...the foreign key corresponding to the old parent PK is set to null - the
dependent rows become orphans. Clearly, this action trigger can not be
applied if the foreign key column is non-nullable..." page 302
Could you please explain.
Thank you
danieL
____________________________
Comvision Pty. Ltd.
www.comvision.net.au
This is a question for Helen, as I have been reading her Book, and I am not
sure I understand the following statement:
"...the foreign key corresponding to the old parent PK is set to null - the
dependent rows become orphans. Clearly, this action trigger can not be
applied if the foreign key column is non-nullable..." page 302
Could you please explain.
Thank you
danieL
____________________________
Comvision Pty. Ltd.
www.comvision.net.au