Deleting a Relationship for Previous Generations

Hi! How can I remove a BOM relationship for previous generations of a Part? I tried to write a SQL Query but I couldn't mange it. thanks