Progress
SQL-89
Guide and Reference
Deleting Rows
The searched DELETE statement deletes one or more rows from a table. The DELETE statement has the following syntax.
The WHERE clause identifies the rows to delete. If you omit the WHERE clause, all rows of the target table are deleted. See the "Specifying Search Conditions" section for details on the search conditions used in WHERE clauses.
The following example deletes item number 51 from the item table.
This example uses the LIKE search condition to specify the rows for deletion.
See the "Positioned DELETE" section for information on the positioned DELETE statement.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |