Last answered:

19 Oct 2022

Posted on:

28 Sept 2022

1

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 

6 answers ( 1 marked as helpful)
Instructor
Posted on:

03 Oct 2022

1

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

Posted on:

03 Oct 2022

0

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.

Instructor
Posted on:

09 Oct 2022

0

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

Posted on:

10 Oct 2022

0

Thank you again,
I have another question that hasn't been answered yet.

Instructor
Posted on:

17 Oct 2022

0

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

Posted on:

19 Oct 2022

0

Hello again, question link
https://365datascience.com/q/203002e33c

Submit an answer