>>>What is the correct syntax? TIA
>>
>>I don't think there is a way.
>
>Do think that in this case instead of setting ON DELET in foreign key constraint I need to do it in Trigger?
Yes, with the trigger you can do this.
If it's not broken, fix it until it is.
My Blog