Progress
SQL-89
Guide and Reference


DELETE FROM Statement

Deletes one or more rows from a table.

SYNTAX
DELETE FROM table-name 
  [ WHERE { search-condition | CURRENT OF cursor-name } ] 

FROM table-name

The name of the table from which to delete rows.

WHERE search-condition

Identifies the rows to delete. If you omit the WHERE clause, all rows of the target table are deleted.

WHERE CURRENT OF cursor-name

Identifies the cursor that points to the row to delete (positioned delete).

EXAMPLE

This example deletes records with customer numbers greater than 100 from the customer table.

DELETE FROM Customer                                  
  WHERE Cust-Num > 100. 

NOTES

SEE ALSO

CLOSE Statement, DECLARE CURSOR Statement, FETCH Statement, INSERT INTO Statement, OPEN Statement, UPDATE Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095