picoSQL - Language reference manual

Syntax:

DELETE FROM table-name [WHERE {search-condition| CURRENT OF cursor-name}]

Purpose:

Allows to delete an arbitrary number of rows from a table.

See also:

INSERT, UPDATE, SELECT

Description:

This statement deletes all the rows from the named table that satisfy the search condition. If the WHERE clause is not specified, all the rows from the table are deleted. The CURRENT OF clause can be used, instead of the search condition, to delete only the current row read by a cursor. However, this clause can be used only from a program language because a cursor name can be gotten or set only calling an API (SQLGetCursorName and SQLSetCursorName respectively).