Command DELETE - SQL Foundation
Deletes one or more records in a table. END
DELETE FROM <cTableName> [WHERE <lExpression>] [VIA (<coSession>)]
Records marked for deletion using SQL DELETE are only physically removed from the table when the PACK command is used. Until that point, records which are marked for deletion can be "undeleted" with the RECALL command.
If SET DELETED is ON, the records marked for deletion are ignored by all database commands in which a scope is specified.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.