DELETE

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

DROP TABLE

TRUNCATE TABLE