android sqlite issue in deleting child info from table

android: Suppose there is a main table containing a primary key and there is another table which contains a foreign key to this main table. So if we delete the row of main table it will delete the child table also.

any example is appreciated