Does the child table have constrain_file to the parent? That stops the clear.