Resolved: CASCADE FUNCTION
can we use more than 1 function before the cascade?
................... ON DELETE OR UPDATE OR DROP CASCADE
logical operations
or
using *
...................ON * CASCADE
Hi Peter!
Thanks for reaching out.
Yes, you can, but the syntax to abide by doesn't require us to use OR. Instead, we need to list the operations one by one. Here's an example of the structure to use:
...
ON DELETE CASCADE
ON UPDATE CASCADE
...
Hope this helps.
Best,
Martin
Thank you for your answer,
I didn't mean to use OR
I meant ( * ) to use all the functions instead of writing it one but one.
Hi Peter!
Thank you for getting back to us.
Yes, regardless you referred to using OR or ( * ), the syntax I suggested is the one to abide by when using Cascade multiple times in a query.
Hope this helps.
Best,
Martin
Thank you again,
I have another question that hasn't been answered yet.
Hi Peter!
Please excuse us for the inconvenience. As of now, I am unable to locate the question you are referring to.
Can you please post a link to the question you've created in the Q&A? Then, I can look for the right person to provide an answer to it.
Thank you!
Kind regards,
Martin
Hello again, question link
https://365datascience.com/q/203002e33c