Syntax

1. <delete_statement> ::=
     DELETE [FROM] <table_name>
       [<reference_name>]
       [KEY <key_spec>,...] <!  This SQL clause is
             no longer recommended to be used
             and might be removed from future versions.  !>
       [WHERE <search_condition>]
       [IGNORE TRIGGER]
       [NOWAIT]
   | DELETE [FROM] <table_name>
       [<reference_name>]
       WHERE CURRENT OF <result_table_name>
       [NOWAIT]