DELETE FROM --+-> table-name -+-+----->----+-+
               +-> view-name --+ +-> alias -+ |
    +-----------------------------------------+
    ++------------>-------------------------+-> ;
     +-> WHERE -+-> predicate --------------+
                +-> CURRENT OF cursor-name -+

Additional information available:

WHERE

More Informationtable nameview namealias

 The DELETE statement deletes a row from a table or view.

 The name of the target table from which you want to delete a row.

 The name of the target view from which you want to delete a row.

 An alias you can use to identify the table or view in the predicate
 of the DELETE statement.  See help on aliases for more information.

 The WHERE clause specifies the rows of the target table or view that
 will be deleted.  If you omit the WHERE clause, SQL deletes all rows
 of the target table or view.  You can either specify a predicate or a
 cursor name in the WHERE clause.

 If the WHERE clause includes a predicate, all the rows of the target
 table for which the predicate is true are deleted.  The columns named
 in the predicate must be columns of the target table or view.  The
 target table cannot be named in a column select expression within the
 predicate.

 If the WHERE clause uses CURRENT OF cursor-name, SQL deletes only the
 row on which the named cursor is positioned.  The cursor must have
 been named previously in a DECLARE CURSOR statement, must be open,
 and must be positioned on a row.  In addition, the FROM clause of the
 SELECT statement within the DECLARE CURSOR statement must refer to
 the table or view that is the target of the DELETE statement.