Command DELETE - SQL Foundation
Deletes one or more records in a table. END
Syntax
DELETE FROM <cTableName>
[WHERE <lExpression>]
[VIA (<coSession>)]
Parameters
<cTableName>
<cTableName> specifies the name of the table containing the records to be deleted.
WHERE <lExpression>
Specifies one or more filter conditions the records must meet in order to be deleted.
VIA (<oSession>)
<oSession> optionally specifies the Session context for the operation. oSession is an object of DacSession() or any derived class and must be specified as an object expression in parentheses. If <oSession> is not specified, the SQL DELETE statement is executed by the local SQL engine. If a VIA clause is specified in an SQL statement on the other hand, the statement executes in the context defined by the session which in most cases involves a remote backend.
Description
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.
Examples
Feedback
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.