Hi team,
Pls let me know , how this cascade+ restricted will work?
Suppose I have 3 tables
Table A (Parent)
Table B (Child)
Table C (Grand child)
I have defined delete action = Cascade in table B and
Delete action = Restricted in Table C.
When will trying to delete record from Table A, it will trying to delete record from Table B, because it has "Cascade". Before deleting the record in Table B, it will check whether record is existed in Table C or not.
Here is two possibilities:
If record existed in Table C, and it has "Restricted". So, failed to delete record from both Table A and Table B.
If record is not existed in Table C, then it will delete the record from Table A and Table B.
Am i correct ?
Pls advise. thanks!
