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