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.

SYNTAX
DELETE FROM table-name [ WHERE search-condition ] 

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.

DELETE FROM Item
     WHERE Item-Num = 51. 

This example uses the LIKE search condition to specify the rows for deletion.

DELETE FROM Item
     WHERE Item-Name LIKE ’Croquet%’. 

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