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

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