>Hi,
> I have define parent and child relationship for my tables. I would like to ask, how would you handle the issue of update cascade to parent table if some of the records of child records purged?
>
>Thank you

You could add code to the delete trigger of the child record.