© Kevin Languedoc 2016

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

4. Altering Databases and Other Features

Kevin Languedoc

(1)Montreal, Canada

SQLite doesn’t have an extensive API for modifying databases. Nevertheless, it does still offer functions to alter tables, and we can still alter views, triggers, and indexes as well as functions.

This chapter will focus on demonstrating SQLite’s altering capabilities as well as on modifying a database using the platform’s other tools, including the following:

  • Altering table

  • Modifying views

  • Modifying indexes

  • Modifying triggers

  • Re-indexing a table

  • Deleting tables

  • Deleting views

  • Deleting indexes

  • Deleting triggers

In this section of the chapter, I will add the modifying ...

Get Build iOS Database Apps with Swift and SQLite now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.