The DELETE Statement - Firebird

The DELETE query is used for deleting whole rows from a table. SQL does not allow a single DELETE statement to erase rows in more than one table. A DELETE query that modifies only the current row of a cursor is known as a positioned delete. One that may delete multiple rows is known as a searched delete. The DELETE statement has the following general form:

DELETE FROM table-name [WHERE <search predicates> | WHERE CURRENT OF cursor-name]

If a WHERE clause is not specified, every row in the table will be deleted.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics