The DELETE statement removes an occurrence from a table in the database. This statement requires the primary key to be available in one of the following ways:
You can specify which occurrence to remove by basing your selection criteria on the primary key field and using the equality relational operator (=). No other field selection is allowed.
If you delete an occurrence using a DELETE statement, you must commit the update to the table before you can retrieve the updated data. Otherwise, previously committed data that does not reflect your update is retrieved from the database. Refer to
COMMIT Statement for more information about committing data.