SQL Guide : solidDB® SQL statements : DELETE
  
DELETE
DELETE FROM table_name [WHERE search_condition]
DELETE FROM table_name WHERE CURRENT OF cursor_name
Usage
There are two types of DELETE statements:
The searched DELETE statement, DELETE FROM table_name [WHERE search_condition], deletes all rows in a given table or the rows specified with search_condition.
The positioned DELETE statement, DELETE FROM table_name WHERE CURRENT OF cursor_name, deletes the current row of the cursor.
table_name can be a table name or an alias.
Tip: If you want to delete all rows in a table, consider using the TRUNCATE statement.
Example of searched DELETE
DELETE FROM TEST WHERE ID = 5;
DELETE FROM TEST;
Example of positioned DELETE
DELETE FROM TEST WHERE CURRENT OF MY_CURSOR;
Related reference
See also
solidDB® SQL statements