DELETE

This statement removes rows from a table. To delete rows from a table, the IP must mark support for the DELETE operation.

Syntax

<delete-stmt> ::= DELETE FROM <table_name> [<where-clause>]
<where-clause> ::= WHERE <search-condition>

Example

DELETE FROM emp WHERE deptno=40