ABAP Keyword Documentation →  ABAP − Short Reference 

DELETE dbtab - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

DELETE { {FROM dbtab|view|(target_syntax) 
         [USING CLIENT clnt] | [CLIENT SPECIFIED] 

         [CONNECTION con|(con_syntax)] 
   
     [WHERE sql_cond]} 
       | {dbtab|view|(target_syntax) [CLIENT SPECIFIED] 

                 
             [CONNECTION con|(con_syntax)] 
         FROM { wa|{TABLE itab} } } }. 

Effect

Deletes rows from a database table or a classic view.

Additions

• FROM dbtab|view|(target_syntax)
  Specifies the database table and/or view statically or dynamically.
• USING CLIENT
  Switches automatic client handling to the client specified in clnt.
• 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.