O'Reilly logo

Build iOS Database Apps with Swift and SQLite by Kevin Languedoc

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Kevin Languedoc 2016

Kevin Languedoc, Build iOS Database Apps with Swift and SQLite, 10.1007/978-1-4842-2232-4_8

8. Deleting Records

Kevin Languedoc

(1)Montreal, Canada

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required