Deleting Data

There are two types of DELETE statements: positioned and searched.

You can use a DELETE statement to delete one or more rows from a table or an updatable view. To specify specific rows for Pervasive PSQL to delete, use a WHERE clause in a DELETE statement.

DELETE FROM Class
WHERE ID = 005#

The positioned DELETE statement deletes the current row of a view associated with an open SQL cursor.

DELETE WHERE CURRENT OF mycursor;

For more information about the DELETE statement, see the following topic in SQL Engine Reference: DELETE.