SQL support / Static SQL statements |
Removes rows from a database table.
DELETE FROM table-specification [ WHERE { condition | CURRENT OF cursor } ]
where table-specification is:
[dbname[@dbserver]:][owner.]table
The DELETE SQL statement can be used to delete one or more rows from the specified database table.
The dbname, dbserver and owner prefix of the table name should be avoided for maximum SQL portability.
If you do not specify the WHERE clause, all rows in the table will be deleted. No warning will be generated by the compiler.
For more details about the WHERE CURRENT OF clause, see Positioned updates/deletes.
MAIN DATABASE stock DELETE FROM items WHERE name LIKE 'A%' END MAIN