In this chapter, we will discuss the DELETE function in SQLite. In contrast to the other CRUD functions in SQLite, the DELETE function API is the same as in other platforms and implements the basic SQL API, except for the LIMIT clause, which allows a developer to set a limit on the number of rows to delete. We will cover the following:
The DELETE statement
DELETE using a WHERE clause
DELETE restrictions and TRIGGERS
LIMITS
A Swift DELETE example
The DELETE Statement in SQLite
The DELETE statement is a standard SQL statement that is used to permanently remove one or more records ...