Show TOC Start of Content Area

Syntax documentation DELETE Statement  Locate the document in its SAP Library structure

The DELETE statement allows deleting selected rows from a database table.

Syntax

Syntax

<delete statement> ::= DELETE FROM <table name>
                                   
 <where clause> )?

Example

Example

DELETE FROM employees WHERE employee_id = 23

Deleting Rows from a Table.  All rows are witch fulfill the condition employee_id = 23  are deleted from the table employees.

More Information

Table Reference

WHERE Clause

End of Content Area