solidDB Help : solidDB reference : SQL: Statements : DELETE FROM
  
DELETE FROM
DELETE FROM table‑name [WHERE {search‑condition | CURRENT OF cursor‑name}]
Access requirements
DELETE privileges on table
Usage
Use the DELETE FROM statement to delete one, more, or all the rows in a specified table.
Parameters, clauses, keywords, and variables
▪ table‑name: A table name or an alias.
▪ search‑condition: Executes a ‘searched’ DELETE operation where all rows that match the search condition are deleted, see search‑condition.
▪ CURRENT OF: Executes a ‘positioned’ DELETE operation, where just the current row of the cursor is deleted.
If you do not specify the WHERE clause, all rows in the table are deleted. However, if you want to delete all rows in a table, consider using the TRUNCATE TABLE statement, which is more efficient, see TRUNCATE TABLE.
Examples
DELETE FROM TEST WHERE ID = 5;
DELETE FROM TEST WHERE CURRENT OF MY_CURSOR;
Go up to
SQL: Statements