DELETE
Delete rows from a table according to specified criteria.
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 - Specify options to be used for this command.
Options
Example
>CONNECT ORDERS
>DELETE FROM CUSTOMERS WHERE CUSTOMER_NO = 1240
Top
|