Consider classes SEQUENCE and ENTRY, of the OPM schema in Appendix A. The following DELETE statements deletes sequence 123 and all of its entries:
DELETE S FROM S in SEQUENCE WHERE S.sequence_id = 123;
DELETE E FROM E in ENTRY WHERE E.from_sequence.sequence_id = 123;