Filter
Top Products
This section explains the following operation that can be performed by the DELETE statement:
· Deleting all rows from a table
A cursor can also be used to delete data. For information on using a cursor to delete data, see 4.6 "Deleting Data
Using a Cursor".
The method of deleting rows explained in this section is called the "DELETE statement" (searched) because the rows
to be deleted are specified using search conditions.
3.3.1 Deleting all rows from a table
To delete all rows from a table, do not specify search conditions or the keyword "WHERE". The following is an
example of this:
Example:
In this example, all rows are deleted from the ORDER table.
36