DELETE deletes one or more rows from the database table specified
target. The rows that
are to be deleted are declared either in a
sql_cond or with data objects in
|0||In the declaration of a
|4||When specifying a
sy-dbcnt to the number
of deleted rows. If an overflow occurs because the number or rows is greater than 2,147,483,647,
sy-dbcnt is set to -1.
- The rows are deleted permanently from the database table in the next database commit. Until that point, they can still be undone using a database rollback
DELETEsets a database lock until the next database commit or rollback. If used incorrectly, this can produce a deadlock.
The number of rows that can be deleted from the tables of a database within a
database LUW is limited, since a database system can only manage a limited amount of locks and data in the rollback area.