Progress
SQL-89
Guide and Reference
DELETE FROM Statement
Deletes one or more rows from a table.
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).
EXAMPLEThis example deletes records with customer numbers greater than 100 from the customer table.
NOTES
- You can use the DELETE FROM statement in both interactive SQL and ESQL.
- See Data Manipulation Language." for more information about this statement.
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 |