Syntax
DELETE FROM table [WHERE < predicate-list |
CURRENT > [<ON / OF> [CURSOR] cursor]] [WITH options]
DELETE FROM table
Required. table is the name of the table in the database
that contains the rows to be deleted.
WHERE predicate-list | CURRENT
Optional. Caution! If omitted, ALL rows will be deleted from
the specified table.
predicate-list - Criteria to determine which rows will be
deleted.
CURRENT - Delete only the current row.
[ON [CURSOR] cursor]
Optional. The cursor on which to perform the delete. If omitted,
the delete will be performed on the current cursor.
[WITH options]
Optional. A comma separated list of options to use when performing
the delete.
top
OdxSQL Example
top
|