Delete all child tables record when master table record del.

Question

How to delete all child tables record when master table records deleted, in sql? Please explain the how many ways to do it.