4. SQL Statements : DELETE
 
Share this page                  
DELETE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DELETE statement deletes rows from the specified table that satisfy the search_condition in the WHERE clause. If the WHERE clause is omitted, the statement deletes all rows in the table. The result is a valid but empty table.
This statement has the following formats:
Interactive version:
DELETE FROM [schema.]table_name [corr_name]
       [WHERE search_condition];
Embedded non-cursor version:
[REPEATED] DELETE FROM [schema.]table_name [corr_name]
          [WHERE search_condition];
table_name
Specifies the name of the table from which rows are to be deleted.
corr_name
Specifies a correlation name for the table for use in the search_condition.