next up previous contents
Next: Update Queries Up: Delete Queries Previous: Delete Queries

Examples.

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;