ABAP Keyword Documentation →  ABAP - Short Reference 

DELETE dbtab - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

DELETE { {FROM {dbtab|(dbtab_syntax)} [CLIENT SPECIFIED] 
    
                 
               [CONNECTION {con|(con_syntax)}] 

         [WHERE sql_cond]} 

       | {{dbtab|(dbtab_syntax)} [CLIENT SPECIFIED] 
   
                 
           [CONNECTION {con|(con_syntax)}] 
         FROM { wa|{TABLE itab} } } }. 

Effect

Deletes rows from a database table.

Additions

• FROM {dbtab|(dbtab_syntax)}
  Specifies the database table statically or dynamically.
• CLIENT SPECIFIED
  Deactivates automatic client handling.
• CONNECTION {con|(con_syntax)}
  Executes the change on a secondary database connection.
• WHERE sql_cond
  Uses a sql_cond condition to specify the rows that are to be deleted.
• FROM { wa|{TABLE itab} }
  Specifies the rows that are to be deleted by matching them with the key values of a work area wa or the rows of an internal table itab.