>>Hi,
>>
>>I want to be sure that I am setting my FK constraint correctly and want to confirm that the following syntax will do what I want. What I want is on UPDATE of the UNIQUE key to update all foreign keys. And on DELETE of UNIQUE key to set all foreign keys to NULL (not delete). Here is my syntax:
>>
>>
>>alter table... add constraint..
>>ON UPDTATE CASCADE
>>ON DELETE SET NULL
>>
>>
>>Please let me know if I use correct syntax.
>>
>>TIA.
>
>Yes (on UPDATE)
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham