如何删除包含其他表外键的表中的行

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.Suppose there is a main table containing a prim